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
CACHE0;
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