Re: pg_temp.. - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_temp..
Date
Msg-id 24064.984550601@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_temp..  ("Brian Baquiran" <brianb@edsamail.com>)
List pgsql-general
"Brian Baquiran" <brianb@edsamail.com> writes:
> Is it safe to delete these rows from pg_class?
>>
>> Yes, if the backend PIDs that created 'em aren't around anymore.  I'd
>> suggest DROP TABLE rather than a DELETE FROM pg_class.

> Tried that. I get "ERROR:  class "pg_temp.6004.0" is a system catalog". Is
> it because it starts with "pg_"?

Um.  Yeah, probably so.  Sometimes that looks like a feature, and
sometimes it looks like a bug ;-)

            regards, tom lane

pgsql-general by date:

Previous
From: "mikhail malamud"
Date:
Subject: RE: Fw: Please Help
Next
From: David Wheeler
Date:
Subject: NULL vs. Empty String