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@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Tom Lane
> Sent: Friday, January 04, 2008 3:35 PM
> To: Ken Winter
> Cc: PostgreSQL pg-general List
> Subject: Re: [GENERAL] 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq