Re: pg_dumpall and version confusion - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dumpall and version confusion
Date
Msg-id 7314.1174059771@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dumpall and version confusion  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
List pgsql-general
Tony Caduto <tony_caduto@amsoftwaredesign.com> writes:
> I don't think the whole --output-version thing would be a good idea
> either, but it would be a simple matter to add some logic for the
> GRANT ON SEQUENCE, which seems to be the only thing that is really
> causing problems at least between 8.1 and 8.2.

You mean it's the only thing you've run into.  There are a *lot* of
changes in the output of different pg_dump versions.  Even focusing
on the narrow question of sequence changes between 8.1 and 8.2,
what of the change from emitting "SERIAL" to emitting a separate
CREATE SEQUENCE and ALTER SEQUENCE OWNED BY?

            regards, tom lane

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: pg_dumpall and version confusion
Next
From: merlyn@stonehenge.com (Randal L. Schwartz)
Date:
Subject: Re: exception handling in plperlu