Re: pg_dumpall and version confusion

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