Orphaned temp table - Mailing list pgsql-general

From Mike Blackwell
Subject Orphaned temp table
Date
Msg-id CANPAkgsswO4XP6wJ17dCK9tEYpRvbkJ9R4yCTBGAxjfEgzNYhw@mail.gmail.com
Whole thread Raw
Responses Re: Orphaned temp table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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:  00000: autovacuum: found orphan temp table "pg_temp_7"."tmp_order_ids" in database "mydb"
2012-02-27 13:05:35 CST [18400]: [2-1] @ LOCATION:  do_autovacuum, autovacuum.c:2022

__________________________________________________________________________________
Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike.Blackwell@rrd.com
http://www.rrdonnelley.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Having a problem with RoR-3.1.1 and Pg-9.1
Next
From: "James B. Byrne"
Date:
Subject: Re: Having a problem with RoR-3.1.1 and Pg-9.1