Re: pg_dump: schema with OID 16396 does not exist

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump: schema with OID 16396 does not exist
Дата
Msg-id 26697.1156945365@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump: schema with OID 16396 does not exist  (RW <postgres@tauceti.net>)
Ответы Re: pg_dump: schema with OID 16396 does not exist  (RW <postgres@tauceti.net>)
Список pgsql-admin
RW <postgres@tauceti.net> writes:
> pg_dump: schema with OID 16396 does not exist

I assume you don't see that OID in "select oid,nspname from pg_namespace"?

Look through the system catalogs to find the object(s) that claim to be
in that namespace, and then tell us what they are and their history.

select * from pg_type where typnamespace = 16396

and likewise for pg_class.relnamespace, pg_operator.oprnamespace,
pg_conversion.connamespace, pg_opclass.opcnamespace,
pg_aggregate.aggnamespace, pg_proc.pronamespace.

            regards, tom lane

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

Предыдущее
От: RW
Дата:
Сообщение: pg_dump: schema with OID 16396 does not exist
Следующее
От: "Nigel Bishop"
Дата:
Сообщение: Re: Some advice required please