Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group