Re: [ADMIN] Temporary table failed to drop after power failure

Any ideas/recommendation? -Original Message- From: Gnanakumar [mailto:gna...@zoniac.com] Sent: Monday, March 14, 2011 1:40 PM To: pgsql-admin@postgresql.org Subject: Temporary table failed to drop after power failure Hi, We're using PostgreSQL v8.2.3. Ours is a web-based application, l

[ADMIN] Temporary table failed to drop after power failure

Hi, We're using PostgreSQL v8.2.3. Ours is a web-based application, language is Java and we're using pgpool-II v 2.0.1 purely for connection pooling (we don't use other features of pgpool like Replication, Load Balancing, etc.). We're creating temporary table using "CREATE TEMP TABLE FOO(col1, c