Re: Orphaned temp table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Orphaned temp table
Date: 2012-02-27 20:48:35
Message-ID: 18770.1330375715@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mike Blackwell <mike(dot)blackwell(at)rrd(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-02-27 20:54:48 Re: Having a problem with RoR-3.1.1 and Pg-9.1
Previous Message Tom Lane 2012-02-27 20:44:35 Re: Having a problem with RoR-3.1.1 and Pg-9.1