Web pgadmin.org
 Home 
 ·  ·  ·  ·  ·  ·  · 
refreshing object tree

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

top