From: Roman Kunert <rkunert@yobe.org>
To: pgsql-sql@postgresql.org
Subject: disable constrained (contd.)
Date: Sun, 22 Aug 2004 02:41:35 +0200
Message-ID: <4127EBBF.2040405@yobe.org> (raw)
I just wanted to know if there is an update to the topic
http://archives.postgresql.org/pgsql-sql/2003-02/msg00624.php
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)
any news on this? thanks.
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: rkunert@yobe.org
Subject: Re: disable constrained (contd.)
In-Reply-To: <4127EBBF.2040405@yobe.org>
* 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