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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org