From: | "Richard Huxton" <dev(at)archonet(dot)com> |
---|---|
To: | "will trillich" <will(at)serensoft(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall -> fails |
Date: | 2001-02-28 11:51:23 |
Message-ID: | 003b01c0a17d$03d8d5e0$1001a8c0@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
From: "will trillich" <will(at)serensoft(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2001-02-28 11:53:05 | Re: Object |
Previous Message | zaviz2 | 2001-02-28 11:20:36 |