> -----Original Message----- > From: Berend Tober [mailto:[EMAIL PROTECTED]] > Sent: 21 January 2003 13:40 > To: [EMAIL PROTECTED] > 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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
