Everything I'm doing involves only 8.1. I don't have any 8.2 instances at all... Oops, just I just got a message from my tool's developer that the tool uses the 8.2 pg_dump no matter what actual PostgreSQL version it's working on. Sigh. ~ Thanks ~ Ken > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Tom Lane > Sent: Friday, January 04, 2008 3:35 PM > To: Ken Winter > Cc: PostgreSQL pg-general List > Subject: Re: Problem with pg_dump? > > "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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
