> -----Original Message-----
> From: Berend Tober [mailto:btober(at)seaworthysys(dot)com]
> Sent: 21 January 2003 13:40
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Anomolous schemas
> When I open psAdminII (1.4.12), I see listed a number of
> schemas which I don't expect, namely pg_temp_1, pg_temp_2,
> pg_temp_3, etc., along with the public schema, which I expect
> to be there.
> What's up with that?
> They all are "empty", in that the drill-down listing of
> Aggregates, Domains, Functions, Tables, etc., all each have
> zero sub-items. I've deleted these anomolous schemas with no
> apparent harm, but I'm wondering why they keep reappearing,
> and if it really is o.k. to delete them when I happen to be
> in the administrative utiltiy.
Don't delete them. PostgreSQL uses them to store temp objects like you
might get from CREATE TEMP TABLE xyz...
pgadmin-support by date
|Next:||From: Berend Tober||Date: 2003-01-21 13:39:48|
|Subject: Anomolous schemas|
|Previous:||From: Dave Page||Date: 2003-01-21 13:28:07|
|Subject: Re: Strange bug...|