Re: pg_dumpall -> fails

From: "will trillich" <will@serensoft.com>

> so i've got my data recovered (thanks to oliver) and now
> i wanna back it up with a pg_dumpall...
>
> instead, i get 'failed sanity check, type with oid 779927 was no
> found' in the oddest places...
>
>
> % pg_dumpall
>
> [snip!!]
>
> CREATE FUNCTION "get_disid" (int4,varchar ) RETURNS int4 AS '
> SELECT
> id
> FROM
> _dis
> WHERE
> code = $2
> AND
> edu = $1
> ;
> ' LANGUAGE 'SQL';
> CREATE FUNCTION "get_failed sanity check, type with oid 779927 was not
found
> disid" (text,text ) RETURNS int4 AS '
> SELECT
> get_disid( get_eduid($1), $2 )
> ;
> ' LANGUAGE 'SQL';

>
> so what does 'sanity check' mean, and why does it appear
> in the middle of 'get_disid'?

You haven't got a rogue CR somewhere in that function definition have you?
(Edited on Windows, pasted on *nix?)

Try "select oid,typname from pg_type where oid=779927" - My hunch is there's
some problem with your table _dis.

- Richard Huxton