Ð ÐÑÐ, 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 <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
