refreshing object tree
require($_SERVER['DOCUMENT_ROOT']."/includes/top_config.php");
?>
refreshing object tree
hi!
using pgadmin III 1.2.0 post-beta2, oct 16 2004 snapshot on win2k, sp4.
database is pgsql 8.0 beta1 running on the same machine.
i experienced the described behaviour in some earlier snapshots also.
i noticed this: in the object tree i have 19 sequences listed and 20
tables. after deleting a table i still have those 19 sequences while the
tables drop down to 19.
if i click on the "sequences" they get listed in the upper right pane.
the deleted sequence is also shown and upon clicking on it i receive
this error once or twice:
ERROR: relation "analysis_checkbox_test_analysis_checkbox_test_id_seq"
does not exist
and then pgadmin shows this in the sql query window:
-- Sequence: analysis_checkbox_test_analysis_checkbox_test_id_seq
-- DROP SEQUENCE analysis_checkbox_test_analysis_checkbox_test_id_seq;
CREATE SEQUENCE analysis_checkbox_test_analysis_checkbox_test_id_seq
INCREMENT 0
MINVALUE 0
MAXVALUE 0
START 0
CACHE 0;
ALTER TABLE analysis_checkbox_test_analysis_checkbox_test_id_seq OWNER
TO delo;
can pgadmin refresh at least some parts of the object tree if refreshing
everything is not a good thing/idea (slow connections, a lot of data,
etc.)?
perhaps if it could also detect what would be affected after deleting an
object and refresh the respective objects?
thank you for your answers :)
--
regards,
M
Home |
Main Index |
Thread Index