Re: PostgreSQL 8.1.0 catalog corruption

Поиск
Список
Период
Сортировка
От Bob Ippolito
Тема Re: PostgreSQL 8.1.0 catalog corruption
Дата
Msg-id 1C556166-AFD8-429E-83D7-5A5540ED2898@redivi.com
обсуждение исходный текст
Ответ на Re: PostgreSQL 8.1.0 catalog corruption  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: PostgreSQL 8.1.0 catalog corruption  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Nov 21, 2005, at 12:44 PM, Tom Lane wrote:

> Bob Ippolito <bob@redivi.com> writes:
>> mochi=# drop table ping_1132387200;
>> ERROR:  table "ping_1132387200" does not exist
>> mochi=# create table ping_1132387200();
>> ERROR:  type "ping_1132387200" already exists
>
>> I'm not sure what to do about this..
>
> Try dropping the type.
>
> We've seen at least one prior report of a table's rowtype not being
> dropped with the table, but nothing solid enough to debug.  If you can
> find a way to reproduce this, I'm all ears.

I did try that, I guess it didn't make it to the list yet:

mochi=# drop type ping_1132387200;
ERROR:  cache lookup failed for relation 211174567

-bob






В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Are NULLs in Arrays compressed?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: PostgreSQL 8.1.0 catalog corruption