Re: [AOLSERVER] Dropping temporary tables from Postgres 7.1

On 4/15/06, dhogaza@pacifier.com wrote: > I use temporary tables in Postgres 7.1 (via "select foo into temporary > table > bar"). These are needed for a short time only. I expected they would > periodically be deleted. In PG 8.1, at least, they're deleted at session end. AOLserver's db pool

Re: [AOLSERVER] Dropping temporary tables from Postgres 7.1

On Sat, Apr 15, 2006 at 06:39:22PM -0400, Dave Siktberg wrote: > I use temporary tables in Postgres 7.1 (via "select foo into temporary table > bar"). These are needed for a short time only. I expected they would > periodically be deleted. In looking at my vacuum results, it appears they > are p

Re: [AOLSERVER] Dropping temporary tables from Postgres 7.1

> I use temporary tables in Postgres 7.1 (via "select foo into temporary > table > bar"). These are needed for a short time only. I expected they would > periodically be deleted. In PG 8.1, at least, they're deleted at session end. AOLserver's db pool mechanism means that might never happen whi

[AOLSERVER] Dropping temporary tables from Postgres 7.1

I use temporary tables in Postgres 7.1 (via "select foo into temporary table bar"). These are needed for a short time only. I expected they would periodically be deleted. In looking at my vacuum results, it appears they are persisting forever. I can't locate any instructions on how to remove th