Re: pg_dump --data-only problem with PgSQL 8.0

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Jani Averbach <jaa(at)jaa(dot)iki(dot)fi>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump --data-only problem with PgSQL 8.0
Date: 2005-01-24 18:45:23
Message-ID: 20050124184523.GA86801@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-01-24 18:46:38 Re: pg_dump --data-only problem with PgSQL 8.0
Previous Message Kavan, Dan (IMS) 2005-01-24 18:36:42 Re: benchmarks with pgbench