refreshing object tree

From: Miha Radej <miha(dot)radej(at)siix(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: refreshing object tree
Date: 2004-10-21 22:13:48
Message-ID: 4178349C.5010505@siix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message steve fox 2004-10-22 03:48:19 Re: [pgadmin-support] pgadmin3 beta3 build failure at wxMBConv::MB2WC()
Previous Message Gary Doades 2004-10-21 21:06:02 pgAdmin Beta 3 problems