Re: pg_dump data and foreign keys

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: John Smith <john_smith_45678(at)yahoo(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump data and foreign keys
Date: 2003-03-29 18:48:53
Message-ID: 20030329104824.Q12465-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Fri, 28 Mar 2003, John Smith wrote:

> Is data dumped from pg_dump -a supposed to be in order so it doesn't
> cause foreign key conflicts? I'm getting dumps where tables that rely
> on records in other tables are appearing before them.

No, although you can use --disable-triggers (I think I have that right) to
get it to disable triggers on the table (which includes the foreign key
constraints).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2003-03-29 19:33:41 Recursive Stored Procs?
Previous Message Stephan Szabo 2003-03-29 18:48:13 Re: Select aliasses in where and other places of the