From: francescoboccacci@libero.it <francescoboccacci@libero.it>
To: pgsql-admin@postgresql.org
Subject: autovacuum: found orphan temp
Date: Thu, 19 Jul 2012 17:38:50 +0200 (CEST)
Message-ID: <25486882.2125931342712330597.JavaMail.defaultUser@defaultHost> (raw)
Hi all,
in postgresql log file i found a lots of rows like:
autovacuum: found orphan temp table "pg_temp_32"."test11" in database "Test"
I tried to select this table:
select * from "pg_temp_32"."test11"
but i received the follow error:
ERROR: could not open file "base/16385/t32_13288115": No such file or
directory
How i can solve this problem?
Thanks
Francesco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: francescoboccacci@libero.it
Subject: Re: autovacuum: found orphan temp
In-Reply-To: <25486882.2125931342712330597.JavaMail.defaultUser@defaultHost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox