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