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(at)mt(dot)sri(dot)com
Chris Jones SRI International, Inc.