Обсуждение: how should I do to disable the foreign key in postgres?

On 11/13/07, froast <froast@qq.com> wrote:

> in mysql, I used :"set foreign_key_check = 0;" to disable the foreign key
> check, now I'm trying to migrate from mysql to postgres, how should I do to
> disable it?

PostgreSQL isn't really designed to let your data be compromised.
What actual problem are you trying to solve?  Why do you need foreign
key constraints to be ignored?

am  Wed, dem 14.11.2007, um 15:16:48 +0800 mailte froast folgendes:
> in mysql, I used :"set foreign_key_check = 0;" to disable the foreign key
> check, now I'm trying to migrate from mysql to postgres, how should I do
> to disable it?

You can define the constraints as deferrable. Later you can say:

set constraints all deferred ;



Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net