Hi Tom, thanks for your reply.
What is the origin of these schemas? local temporary tables? sorts?
Thanks a lot!
--
Fernando O. Papa
DBA
Claxson - Tecnología
Tel: (54-11) 4546-8000 Int. 3854
Fax: (54-11) 4546-8051
> -----Mensaje original-----
> De: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Enviado el: jueves, 06 de febrero de 2003 18:07
> Para: Fernando Papa
> CC: pgsql-general@postgresql.org
> Asunto: Re: [GENERAL] pg_temp schemas
>
>
> "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
>