Thread: autovacuum: found orphan temp

autovacuum: found orphan temp

From
"francescoboccacci@libero.it"
Date:
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