pg_dumpall -> fails

Поиск
Список
Период
Сортировка
От will trillich
Тема pg_dumpall -> fails
Дата
Msg-id 20010228034304.A4421@mail.serensoft.com
обсуждение исходный текст
Ответы Re: pg_dumpall -> fails  ("Oliver Elphick" <olly@lfix.co.uk>)
Re: pg_dumpall -> fails  (Mario Weilguni <mweilguni@sime.com>)
Список 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 по дате отправления:

Предыдущее
От: "Oliver Elphick"
Дата:
Сообщение: Re: postgresql upgrade/downgrade: the data is BACK! but...
Следующее
От: ochapiteau
Дата:
Сообщение: Re: to_date & to_char with postgres 6.5 & 7.0