pg_temp_N temp schema buildup

From: Jerry Sievers <jerry(at)jerrysievers(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_temp_N temp schema buildup
Date: 2004-05-19 12:32:06
Message-ID: m3brkkzjg9.fsf@prod01.jerrysievers.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marco Lazzeri 2004-05-19 12:50:11 Re: Restricted query
Previous Message CH 2004-05-19 12:31:54 restore from xlog