Re: pg_extension_config_dump() with a sequence

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_extension_config_dump() with a sequence
Дата
Msg-id 12428.1377028988@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_extension_config_dump() with a sequence  (Moshe Jacobson <moshe@neadwerx.com>)
Ответы Re: pg_extension_config_dump() with a sequence  (Moshe Jacobson <moshe@neadwerx.com>)
Список pgsql-general
Moshe Jacobson <moshe@neadwerx.com> writes:
> In searching for a solution I found an old message where Tom suggested
> marking the sequence as a config table in the same way. This seems to work
> OK when I use pg_dump, but for some reason, pg_dumpall generates the
> following error:

It's pretty hard to believe that that would work in pg_dump but not
pg_dumpall.  You sure the error references a database that you fixed the
sequence definition in?  (You'd probably have to drop and recreate the
extension to fix it in an existing database.)  If so, what PG version are
we talking about exactly, and what's the whole pg_dumpall command line?

            regards, tom lane


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

Предыдущее
От: Olivier Chaussavoine
Дата:
Сообщение: Re: earthdistance
Следующее
От: Aram Fingal
Дата:
Сообщение: Alternate input for user defined data type