Postgres Pro
Downloads
Home   >   mailing lists

pg_temp_N temp schema buildup - Mailing list pgsql-general

From Jerry Sievers
Subject pg_temp_N temp schema buildup
Date
Msg-id m3brkkzjg9.fsf@prod01.jerrysievers.com
Whole thread Raw
Responses Re: pg_temp_N temp schema buildup  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pg_temp_N temp schema buildup  (Mike G <mike@thegodshalls.com>)
List pgsql-general
Tree view 
Hello.

I'm running postgres 7.4.1 and notice an accumulation of temp schemas
named pg_temp_1, pg_temp_2... etc.

These schemas are empty and I have manually removed them from time to
time.

What procedure is leaving these behind and is there a way for me to
have them cleaned up automatically after use?

Thanks.

--
-------------------------------------------------------------------------------
Jerry Sievers   305 854-3001 (home)     WWW ECommerce Consultant
                305 321-1144 (mobile    http://www.JerrySievers.com/

pgsql-general by date:

Previous
From: w00t
Date:
Subject: relocation error
Next
From: florence.henry@obspm.fr (Florence HENRY)
Date:
Subject: Does INSERT inserts always at the end ?