Re: pg_temp schemas

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Fernando Papa" <fpapa(at)claxson(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_temp schemas
Date: 2003-02-06 21:07:13
Message-ID: 15734.1044565633@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Fernando Papa" <fpapa(at)claxson(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-06 21:13:08 Re: Cannot insert a duplicate key into unique index pg_calss_oid_index
Previous Message Tom Lane 2003-02-06 21:02:41 Re: Maximum length of a query