RE: failed sanity check, table answers was not found
От | Matthew |
---|---|
Тема | RE: failed sanity check, table answers was not found |
Дата | |
Msg-id | 183FA749499ED311B6550000F87E206C1FD10E@srv.ctlno.com обсуждение исходный текст |
Ответ на | failed sanity check, table answers was not found (Marek Pętlicki <marpet@buy.pl>) |
Список | pgsql-general |
> I receive this error when trying to pg_dump -s > > failed sanity check, table answers was not found > > the failed table name varies. All the problematic tables > seem to work. vacuumdb (-z) also works without any comment. > I had some similar problems with pg_dump on 7.0.3 recently. Tom Lane was able to give me some very specific things to look at. The error I was getting was: > -- dumping out user-defined functions > failed sanity check, type with oid 101993741 was not found And Tom told me, "Looks like you have a function that refers to a since-deleted type. You'll need to find and drop the function (which may mean manually deleting its pg_proc row, since there's no way to name the function to DROP FUNCTION if one of its parameters is a now-unknown type). Another possibility is that the type still exists but you deleted its owning user from pg_shadow; that will confuse pg_dump too. In that case you can just create a new user with the same usesysid, or you can update the type's typowner field in pg_type to refer to some existing user. Try "select * from pg_type where oid = 101993741" to figure out which situation applies ..." Don't know if that will help at all. Seems this is usally something where something references soemthign that doesnt' exist any more, such as a function that returns a datatyp that no longer exists.
В списке pgsql-general по дате отправления: