Re: "temporary" table is still there

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