Re: Problem with pg_dump?

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(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)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(at)sunward(dot)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