Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group