Re: BUG #5338: PG_DUMP fails due to invalid adnum value

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5338: PG_DUMP fails due to invalid adnum value
Дата
Msg-id 26871.1266858830@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #5338: PG_DUMP fails due to invalid adnum value  ("Toni Helenius" <toni.helenius@syncrontech.com>)
Список pgsql-bugs
"Toni Helenius" <toni.helenius@syncrontech.com> writes:
> I tried to google this but I didn't get much info. What is this all about??

> I get the following error while trying to take a dump:
> pg_dump: finding the columns and types of table "bsc_day1_001"
> pg_dump: finding default expressions of table "bsc_day1_001"
> pg_dump: invalid adnum value 25493128 for table "bsc_day1_001"
> pg_dump: *** aborted because of error

Looks like you've got some data corruption in the pg_attrdef catalog :-(
It might be interesting to see what you get from
    select * from pg_attrdef where adrelid = 'bsc_day1_001'::regclass;
which is approximately what pg_dump did here, and didn't like what it
saw.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Toni Helenius"
Дата:
Сообщение: BUG #5338: PG_DUMP fails due to invalid adnum value
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: helo