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

"Esger Abbink" <pggeneral@bumblebeast.com> 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

"Esger Abbink" <pggeneral@bumblebeast.com> 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

It indeed turned out to be a stale reference. Probably the operator was dropped and reloaded without recreating all other referring operators (i guess thats the way to prevent this problem).

Thanks for the hint :)

btw, is there a way to get an overview of all created functions (i assume pg_operator lists all operators and thus all results of CREATE OPERATOR .., where does CREATE FUNCTION .. end up?
(if i missed this in manuals somewhere please save yourself the typing and just point me ;) )

Esger

--
NeoMail - Webmail that doesn't suck... as much.
http://neomail.sourceforge.net

"Esger Abbink" <pggeneral@bumblebeast.com> 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

It indeed turned out to be a stale reference. Probably the operator was dropped and reloaded without recreating all other referring operators (i guess thats the way to prevent this problem).

Thanks for the hint :)

btw, is there a way to get an overview of all created functions (i assume pg_operator lists all operators and thus all results of CREATE OPERATOR .., where does CREATE FUNCTION .. end up?
(if i missed this in manuals somewhere please save yourself the typing and just point me ;) )

Esger

--
NeoMail - Webmail that doesn't suck... as much.
http://neomail.sourceforge.net

"Esger Abbink" <pggeneral@bumblebeast.com> 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

It indeed turned out to be a stale reference. Probably the operator was dropped and reloaded without recreating all other referring operators (i guess thats the way to prevent this problem).

Thanks for the hint :)

btw, is there a way to get an overview of all created functions (i assume pg_operator lists all operators and thus all results of CREATE OPERATOR .., where does CREATE FUNCTION .. end up?
(if i missed this in manuals somewhere please save yourself the typing and just point me ;) )

Esger

--
NeoMail - Webmail that doesn't suck... as much.
http://neomail.sourceforge.net

"Esger Abbink" <pggeneral@bumblebeast.com> 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

It indeed turned out to be a stale reference. Probably the operator was dropped and reloaded without recreating all other referring operators (i guess thats the way to prevent this problem).

Thanks for the hint :)

btw, is there a way to get an overview of all created functions (i assume pg_operator lists all operators and thus all results of CREATE OPERATOR .., where does CREATE FUNCTION .. end up?
(if i missed this in manuals somewhere please save yourself the typing and just point me ;) )

Esger

--
NeoMail - Webmail that doesn't suck... as much.
http://neomail.sourceforge.net

"Esger Abbink" <pggeneral@bumblebeast.com> 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

It indeed turned out to be a stale reference. Probably the operator was dropped and reloaded without recreating all other referring operators (i guess thats the way to prevent this problem).

Thanks for the hint :)

btw, is there a way to get an overview of all created functions (i assume pg_operator lists all operators and thus all results of CREATE OPERATOR .., where does CREATE FUNCTION .. end up?
(if i missed this in manuals somewhere please save yourself the typing and just point me ;) )

Esger

--
NeoMail - Webmail that doesn't suck... as much.
http://neomail.sourceforge.net

"Esger Abbink" <pggeneral@bumblebeast.com> 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

It indeed turned out to be a stale reference. Probably the operator was dropped and reloaded without recreating all other referring operators (i guess thats the way to prevent this problem).

Thanks for the hint :)

btw, is there a way to get an overview of all created functions (i assume pg_operator lists all operators and thus all results of CREATE OPERATOR .., where does CREATE FUNCTION .. end up?
(if i missed this in manuals somewhere please save yourself the typing and just point me ;) )

Esger

--
NeoMail - Webmail that doesn't suck... as much.
http://neomail.sourceforge.net

"Esger Abbink" <pggeneral@bumblebeast.com> 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

It indeed turned out to be a stale reference. Probably the operator was dropped and reloaded without recreating all other referring operators (i guess thats the way to prevent this problem).

Thanks for the hint :)

btw, is there a way to get an overview of all created functions (i assume pg_operator lists all operators and thus all results of CREATE OPERATOR .., where does CREATE FUNCTION .. end up?
(if i missed this in manuals somewhere please save yourself the typing and just point me ;) )

Esger

--
NeoMail - Webmail that doesn't suck... as much.
http://neomail.sourceforge.net

wtf?

i dont know what happened, my apologies.

(and i hope this one doesnt start multiplying...)

On Thu, 2002-01-17 at 10:31, Esger Abbink wrote:

NeoMail - Webmail that doesn't suck... as much.

Well it is this morning!!!

This is the 7th copy of the same mail I recieved in 5 minutes

Cheers

Tony

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html

--
NeoMail - Webmail that doesn't suck... as much.
http://neomail.sourceforge.net