Re: pg_temp..

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_temp..
Дата
Msg-id 24064.984550601@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_temp..  ("Brian Baquiran" <brianb@edsamail.com>)
Список 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 по дате отправления:

Предыдущее
От: "mikhail malamud"
Дата:
Сообщение: RE: Fw: Please Help
Следующее
От: David Wheeler
Дата:
Сообщение: NULL vs. Empty String