[GENERAL] pg_dumpall -> fails

[will trillich]

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'?

-- 
[EMAIL PROTECTED]