Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx> 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
