From: Markus Bertheau <twanger@bluetwanger.de>
To: Roman Kunert <rkunert@yobe.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: disable constrained (contd.)
Date: Mon, 23 Aug 2004 13:51:53 +0200
Message-ID: <1093261912.2647.10.camel@dicaprio.akademie1.de> (raw)
In-Reply-To: <4127EBBF.2040405@yobe.org>
References: <4127EBBF.2040405@yobe.org>
В Вск, 22.08.2004, в 02:41, Roman Kunert пишет:
> I am also looking for an easy way to disable foreign key constraint
> check while importing data from one database to PostgreSQL. The one
> suggested method (see link above) that modifies pg_catalog.pg_class is
> not preferrable, as it requires super user rights, the other one that
> works by dropping the foreign key, doing the inserts and then adding it
> back again does not seem to work, as it results in an constraint check
> error when I execute the ADD statement (it complains about the reference
> to a row in another table that has not been imported yet, but will be
> later during the import)
Add the constraint when you're done importing all data.
--
Markus Bertheau <twanger@bluetwanger.de>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: twanger@bluetwanger.de, rkunert@yobe.org
Subject: Re: disable constrained (contd.)
In-Reply-To: <1093261912.2647.10.camel@dicaprio.akademie1.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox