Re: [GENERAL] Orphaned temp table

2012-02-27 Thread Tom Lane
Mike Blackwell writes: > Autovacuum is complaining about an orphaned temp table. I believe this was > created just before a recent PostgreSQL crash. Is there something I should > do to clean it up? You could drop that table manually if you're so inclined (probably need to be superuser to do so)

[GENERAL] Orphaned temp table

2012-02-27 Thread Mike Blackwell
Autovacuum is complaining about an orphaned temp table. I believe this was created just before a recent PostgreSQL crash. Is there something I should do to clean it up? 2012-02-27 13:05:35 CST [18400]: [1-1] @ LOG: 0: autovacuum: found orphan temp table "pg_temp_7"."tmp_order_ids" in databa