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

Re: Anomolous schemas

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Berend Tober" <btober(at)seaworthysys(dot)com>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: Anomolous schemas
Date: 2003-01-21 13:38:57
Message-ID: 03AF4E498C591348A42FC93DEA9661B8259AF4@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support

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

pgadmin-support by date

Next:From: Berend ToberDate: 2003-01-21 13:39:48
Subject: Anomolous schemas
Previous:From: Dave PageDate: 2003-01-21 13:28:07
Subject: Re: Strange bug...

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