disable constrained (contd.)
| От | Roman Kunert |
|---|---|
| Тема | disable constrained (contd.) |
| Дата | |
| Msg-id | 4127EBBF.2040405@yobe.org обсуждение исходный текст |
| Ответы |
Re: disable constrained (contd.)
|
| Список | pgsql-sql |
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.
В списке pgsql-sql по дате отправления: