Re: oid problem with dumping database (failed sanity check, opr with oid 280515 was not found)

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: oid problem with dumping database (failed sanity check, opr with oid 280515 was not found)
Дата
Msg-id
9455.1011196662@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Re: oid problem with dumping database (failed sanity check, opr with oid 280515 was not found) "Esger Abbink" <pggeneral@bumblebeast.com>
"Esger Abbink"  writes:
> i have a problem dumping a db. somewhere along the way pg_dump stops with the following error:
 
> failed sanity check, opr with oid 280515 was not found

You have an operator whose oprcom, oprnegate, oprlsortop, or oprrsortop
field points at a no-longer-existing operator.  Look in pg_operator for
the row(s) mentioning that OID and get rid of those operators too.
(Or, manually set the fields to 0 if you want to keep the operators that
have the dangling pointers.)

			regards, tom lane
В списке pgsql-general по дате отправления
От: Henrik Steffen
Дата:
Сообщение: PQsendQuery: Query is too long
От: Doug McNaught
Дата:
FAQ