Jerry Sievers [EMAIL PROTECTED] writes:
I'm running postgres 7.4.1 and notice an accumulation of temp schemas
named pg_temp_1, pg_temp_2... etc.
That's intentional. Removing them just causes extra work to add them
again later (not to mention possibly crashing any backend that is
actively using
I believe they are created when either a function / program creates a temporary table.
On Wed, May 19, 2004 at 08:32:06AM -0400, Jerry Sievers wrote:
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
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