Subject: Re: disable constrained (contd.)
From: Markus Bertheau <twanger@bluetwanger.de>
To: Roman Kunert <rkunert@yobe.org>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <4127EBBF.2040405@yobe.org>
References: <4127EBBF.2040405@yobe.org>
Content-Type: text/plain; charset=UTF-8
Message-Id: <1093261912.2647.10.camel@dicaprio.akademie1.de>
Mime-Version: 1.0
Date: Mon, 23 Aug 2004 13:51:53 +0200
Content-Transfer-Encoding: quoted-printable

=D0=92 =D0=92=D1=81=D0=BA, 22.08.2004, =D0=B2 02:41, Roman Kunert =D0=BF=D0=
=B8=D1=88=D0=B5=D1=82:

> I am also looking for an easy way to disable foreign key constraint=20
> check while importing data from one database to PostgreSQL. The one=20
> suggested method (see link above) that modifies pg_catalog.pg_class is=20
> not preferrable, as it requires super user rights, the other one that=20
> works by dropping the foreign key, doing the inserts and then adding it=
=20
> back again does not seem to work, as it results in an constraint check=20
> error when I execute the ADD statement (it complains about the reference=
=20
> to a row in another table that has not been imported yet, but will be=20
> later during the import)

Add the constraint when you're done importing all data.

--=20
Markus Bertheau <twanger@bluetwanger.de>