Re: Anomolous schemas

> -----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...

Regards, Dave.