Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id B7145F6332B
	for <pgsql-admin@postgresql.org>; Thu, 19 Jul 2012 12:39:05 -0300 (ADT)
Received: from outrelay02.libero.it ([212.52.84.102])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <francescoboccacci@libero.it>) id 1Srsoi-0006c4-FZ
	for pgsql-admin@postgresql.org; Thu, 19 Jul 2012 15:39:05 +0000
X-CTCH-Spam: Unknown
X-CTCH-RefID: str=0001.0A0B0201.50082A0A.013E,ss=1,re=0.000,fgs=0
X-libjamoibt: 1821
Received: from wmail60 (172.31.0.57) by outrelay02.libero.it (8.5.140.03)
	id 500825E80000C351 for pgsql-admin@postgresql.org;
	Thu, 19 Jul 2012 17:38:50 +0200
Message-ID: <25486882.2125931342712330597.JavaMail.defaultUser@defaultHost>
Date: Thu, 19 Jul 2012 17:38:50 +0200 (CEST)
From: "francescoboccacci@libero.it" <francescoboccacci@libero.it>
Reply-To: "francescoboccacci@libero.it" <francescoboccacci@libero.it>
To: pgsql-admin@postgresql.org
Subject: autovacuum: found orphan temp
MIME-Version: 1.0
Content-Type: text/plain;charset="UTF-8"
Content-Transfer-Encoding: 7bit
X-SenderIP: 213.182.95.210
X-libjamv: Jn8wiVBQFdc=
X-libjamsun: P5L2cfaqri0hpXYrgaEvMYL7pZ6kLP1Gbv/N8j39IJI=
X-Pg-Spam-Score: -0.0 (/)
X-Archive-Number: 201207/46
X-Sequence-Number: 39763

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