pg_dumpall -> fails
От | will trillich |
---|---|
Тема | pg_dumpall -> fails |
Дата | |
Msg-id | 20010228034304.A4421@mail.serensoft.com обсуждение исходный текст |
Ответы |
Re: pg_dumpall -> fails
Re: pg_dumpall -> fails |
Список | 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
В списке pgsql-general по дате отправления: