Re: Problem with pg_dump?

"Ken Winter" <ken@sunward.org> writes:
> When I do a pg_dump from an 8.1 database (with options schema-only,
> no-owner, and plain format), the dump file includes the following:

> ALTER SEQUENCE transaction_transaction_id_seq OWNED BY
> "transaction".transaction_id;

Don't use 8.2 pg_dump if you are intending to reload the output into
8.1.  In general, pg_dump's output is not promised to be backward
compatible with older server versions.

> (Full disclosure: I am actually getting this error when working through the
> tool "PG Lightning Assistant" (see
> http://www.amsoftwaredesign.com/lightning_admin.php).

There are some "helpful" tools that seem not to be aware that pg_dump
and server versions are closely linked.

            regards, tom lane