Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_temp schemas - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_temp schemas
Date
Msg-id 15734.1044565633@sss.pgh.pa.us
Whole thread Raw
In response to pg_temp schemas  ("Fernando Papa" <fpapa@claxson.com>)
List pgsql-general
Tree view 
"Fernando Papa" <fpapa@claxson.com> writes:
> We are using postgres on solaris 7.3.1. for several weeks.
> Today I see several schemas nammed pg_temp_1, pg_temp_6, pg_temp_10,
> pg_temp_7, pg_temp_9.

This is normal.  The temp schemas are left around, since there doesn't
seem to be much reason to delete catalog entries only to have to create
them again.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Maximum length of a query
Next
From: Bruno Wolff III
Date:
Subject: Re: Pg_dumpall problem[2]