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 empt
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 us
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
