Thread: "temporary" table is still there

Last Friday, I started a psql script that created a temporary table,
shuffled lots of data through it, and dropped it.  Unfortunately, the
machine crashed before the script finished.

Now I have a table called pg_temp.1548.0, and I can't delete it:

fastfacts=> drop table "pg_temp.1548.0";
ERROR:  class "pg_temp.1548.0" is a system catalog

The same thing happens, whether I'm connected as a mortal user or as
the PG super-user.

What now?

Chris

--
----------------------------------------------------- chris@mt.sri.com
Chris Jones                                    SRI International, Inc.

Chris Jones <chris@mt.sri.com> writes:
> Now I have a table called pg_temp.1548.0, and I can't delete it:
> fastfacts=> drop table "pg_temp.1548.0";
> ERROR:  class "pg_temp.1548.0" is a system catalog
> The same thing happens, whether I'm connected as a mortal user or as
> the PG super-user.

I think you need to restart the postmaster with "-o -O"
(allowSystemTableMods) to be allowed to drop that table.

Perhaps temp tables shouldn't be protected quite as fiercely as the
system catalogs are ;-)

            regards, tom lane