Re: pg_extension_config_dump() with a sequence - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_extension_config_dump() with a sequence
Date
Msg-id 12428.1377028988@sss.pgh.pa.us
Whole thread Raw
In response to pg_extension_config_dump() with a sequence  (Moshe Jacobson <moshe@neadwerx.com>)
Responses Re: pg_extension_config_dump() with a sequence  (Moshe Jacobson <moshe@neadwerx.com>)
List 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 by date:

Previous
From: Olivier Chaussavoine
Date:
Subject: Re: earthdistance
Next
From: Aram Fingal
Date:
Subject: Alternate input for user defined data type