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

Tony Caduto <tony_caduto@amsoftwaredesign.com> writes:
> Alvaro Herrera wrote:
>> What's wrong with that?  8.2 will understand the GRANT ON SEQUENCE
>> without a problem.
>>
> Yes, but 8.1 and earlier wont!

You're missing the point entirely.  The versioning contract for pg_dump
is that version M.N can dump from servers of versions <= M.N, but the
dump it produces is meant to load into server versions >= M.N.  If you
want a dump that will reload into 8.1, use 8.1's pg_dump.

pg_dump is messy enough already just trying to support this contract.
I have *no* interest in trying to get it to support an --output-version
switch...

            regards, tom lane