Re: pg_dump: query to get data of sequence "blahblahthis" returned name "blahblahthat"

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: pg_dump: query to get data of sequence "blahblahthis" returned name "blahblahthat"
Дата
Msg-id
29289.1034823690@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
pg_dump: query to get data of sequence "blahblahthis" returned name "blahblahthat" "Robert John Shepherd" <robert@reviewer.co.uk>
Re: pg_dump: query to get data of sequence "blahblahthis" returned name "blahblahthat" Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump: query to get data of sequence "blahblahthis" returned name "blahblahthat" "Robert John Shepherd" <robert@reviewer.co.uk>
"Robert John Shepherd"  writes:
> When trying to do a pg_dumpall I get:
> dumping database "Reviewer"...
> pg_dump: query to get data of sequence "intartistmemberindex_key"
> returned name "tblartistsmembers_intartistmemb"
> pg_dump failed on Reviewer, exiting

> Having googled around a bit I've discovered this is because I have
> renamed a few sequences.

Yup.

> is there any known fix to work around this problem?

Sure, remove the test in pg_dump that looks at the sequence_name field
of the sequence.  We decided that was a dumb idea and diked it out for
7.3 ...

			regards, tom lane
В списке pgsql-general по дате отправления
От: Adam Siegel
Дата:
Сообщение: pg_dump on large columns
От: Lamar Owen
Дата:
FAQ