Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)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