Re: Orphaned temp table - Mailing list pgsql-general

From Tom Lane
Subject Re: Orphaned temp table
Date
Msg-id 18770.1330375715@sss.pgh.pa.us
Whole thread Raw
In response to Orphaned temp table  (Mike Blackwell <mike.blackwell@rrd.com>)
List pgsql-general
Mike Blackwell <mike.blackwell@rrd.com> 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), or just wait for it to go away the next time
some session uses the pg_temp_7 temp schema.  There's nothing terribly
magic there.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Having a problem with RoR-3.1.1 and Pg-9.1
Next
From: Adrian Klaver
Date:
Subject: Re: Having a problem with RoR-3.1.1 and Pg-9.1