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
