"Ken Winter" <ken@xxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
