Skip site navigation (1) Skip section navigation (2)

temporarily offset foreign key constraints

From: "George Kao" <george(dot)kao(at)group-upc(dot)com>
To: <torontopug(at)postgresql(dot)org>
Subject: temporarily offset foreign key constraints
Date: 2009-02-06 22:07:51
Message-ID: EEACD3D5962B425799F2BC11069CCD14@nitrex.com (view raw or flat)
Thread:
Lists: torontopug
Hello, 
 
Is there any sql command that is equivalent to 
set foreign_key_checks=0;  (of Mysql)
in posgresql?
 
Basically, I would like to some updates of data on the key field which has
the foreign key constraints? Any suggestion of how this can be achieved?
 
Thanks
George
 
 
 
 

torontopug by date

Next:From: pavel zaitsevDate: 2009-04-15 00:27:51
Subject: next meetup
Previous:From: Steve SingerDate: 2009-01-30 23:19:30
Subject: Re: auto vacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group