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