Re: pg_dump --data-only problem with PgSQL 8.0 - Mailing list pgsql-admin

From Michael Fuhr
Subject Re: pg_dump --data-only problem with PgSQL 8.0
Date
Msg-id 20050124184523.GA86801@winnie.fuhr.org
Whole thread Raw
In response to pg_dump --data-only problem with PgSQL 8.0  (Jani Averbach <jaa@jaa.iki.fi>)
List pgsql-admin
On Mon, Jan 24, 2005 at 11:16:56AM -0700, Jani Averbach wrote:

> What I am doing wrong? Or have I found an ordering bug with pg_dump
> when you are doing "--data-only" dumps?

In a simple test I see the same ordering (alphabetical?) whether I
use --data-only or not.  The schema+data dump succeeds because the
dump doesn't add foreign key constraints until after all the data
is loaded.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-admin by date:

Previous
From: "Kavan, Dan (IMS)"
Date:
Subject: Re: benchmarks with pgbench
Next
From: Tom Lane
Date:
Subject: Re: pg_dump --data-only problem with PgSQL 8.0