Re: pg_dump failed sanity check and user defined types

Brook Milligan <brook(at)biology(dot)nmsu(dot)edu> writes:
> However, I have one database with a user defined type and get the
> following error from pg_dump:
> pg_dump -sc -D test > pg_dump.schema || true
> failed sanity check, type with oid 3516132 was not found
> Any clues about this? Does it matter?

Sounds like you dropped a user type without remembering to drop all
the functions/operators defined for it. Unfortunately there's no
safety cross-check in DROP TYPE (probably there should be).

It does matter, since IIRC pg_dump aborts when it finds such an
inconsistency; so you're getting an incomplete dump.

You should be able to find the offending entries by searching through
the system catalogs with queries like
select * from pg_operator where oprleft = 3516132

regards, tom lane