Re: pg_temp.<pid>.<int>

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Brian Baquiran" <brianb(at)edsamail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_temp.<pid>.<int>
Date: 2001-03-14 06:16:41
Message-ID: 24064.984550601@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Brian Baquiran" <brianb(at)edsamail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Wheeler 2001-03-14 06:26:21 NULL vs. Empty String
Previous Message mikhail malamud 2001-03-14 06:07:26 RE: Fw: Please Help