pg_dumpall -> fails

From: will trillich <will(at)serensoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dumpall -> fails
Date: 2001-02-28 09:43:04
Message-ID: 20010228034304.A4421@mail.serensoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)serensoft(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ochapiteau 2001-02-28 09:49:54 Re: to_date & to_char with postgres 6.5 & 7.0
Previous Message Karel Zak 2001-02-28 09:41:25 Re: to_date & to_char with postgres 6.5 & 7.0