Re: pg_dump data and foreign keys - Mailing list pgsql-general

From Stephan Szabo
Subject Re: pg_dump data and foreign keys
Date
Msg-id 20030329104824.Q12465-100000@megazone23.bigpanda.com
Whole thread Raw
In response to pg_dump data and foreign keys  (John Smith <john_smith_45678@yahoo.com>)
List 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).


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Select aliasses in where and other places of the
Next
From: Ben
Date:
Subject: Recursive Stored Procs?