Re: [GENERAL] cleanup of pg_temp schemas

2005-01-26 Thread Martijn van Oosterhout
On Wed, Jan 26, 2005 at 02:28:46PM +0100, Marcel Gsteiger wrote: > Hi all, > > My PostgreSQL app uses temporary tables. After some time, my database > shows lots of pg_temp_xxx schemas with no data inside. I tried to do > a vacuum full analyze to get rid of them, but they still persisted. In gene

Re: [GENERAL] cleanup of pg_temp schemas

2005-01-26 Thread Tom Lane
"Marcel Gsteiger" <[EMAIL PROTECTED]> writes: > My PostgreSQL app uses temporary tables. After some time, my database shows > lots of pg_temp_xxx schemas with no data inside. I tried to do a vacuum full > analyze to get rid of them, but they still persisted. Ignore them.