Re: disable constrained (contd.)

В Вск, 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(at)bluetwanger(dot)de>