Re: Vacuuming leaked temp tables (once again)

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Matthew T. O'Connor" <matthew@zeut.net>
Cc: Gregory Stark <stark@enterprisedb.com>, pgsql-hackers@postgreSQL.org
Date: 2008-06-28T02:34:26Z
Lists: pgsql-hackers
"Matthew T. O'Connor" <matthew@zeut.net> writes:
> Is there an easy way for an Admin clean-up the lost temp tables that 
> autovacuum is complaining about?  It seems like it could be along time 
> and a lot of log messages between when they are first orphaned and and 
> finally dropped due to anti-wraparound protection.

Drop the particular temp schema, maybe?  The log message should probably
make sure to specify the schema name.

			regards, tom lane