Re: pg_dump: schema with OID xxxxxxxx does not exist

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump: schema with OID xxxxxxxx does not exist
Дата
Msg-id 3550.1162174753@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump: schema with OID xxxxxxxx does not exist  (Peter Neish <peter@austehc.unimelb.edu.au>)
Ответы Re: pg_dump: schema with OID xxxxxxxx does not exist
Список pgsql-admin
Peter Neish <peter@austehc.unimelb.edu.au> writes:
> Tom Lane wrote:
>> These are composite-type entries, which means there should be
>> associated entries in pg_class --- with OIDs 37894096 and 37894098
>> respectively.  Did you check to see if those are still there?

> Yes, they are there. Can I safely delete the rows from both the pg_type
> and the pg_class tables?

Oh, that's interesting.  Are there entries in pg_attribute for these
tables?  Look for attrelid = 37894096 or 37894098.  What PG version
is this exactly?

            regards, tom lane

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

Предыдущее
От: Peter Neish
Дата:
Сообщение: Re: pg_dump: schema with OID xxxxxxxx does not exist
Следующее
От: Peter Neish
Дата:
Сообщение: Re: pg_dump: schema with OID xxxxxxxx does not exist