pg_dumpall -> fails - Mailing list pgsql-general

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';
CREATE FUNCTION "get_courseid" (int4,varchar,varchar,bpchar ) RETURNS int4 AS '
    SELECT
        id
    FROM
        _course
    WHERE
        dis      = $1 -- discipline ID
        AND
        code     = $2 -- course abbrev
        AND
        language = $3 -- language
        AND
        medium   = $4 -- media
    ;
' LANGUAGE 'SQL';

[snip]

CREATE FUNCTION "get_studentid" (varchar ) RETURNS int4 AS '
    SELECT
        who
    FROM
        _student
    WHERE
        _student.who = _who.id
        AND
        _who.login = $1;
' LANGUAGE 'SQL';
\connect - will
pg_dump failed on ed, exiting


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

--
will@serensoft.com