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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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




Browse torontopug by date

  From Date Subject
Next Message pavel zaitsev 2009-04-15 00:27:51 next meetup
Previous Message Steve Singer 2009-01-30 23:19:30 Re: auto vacuum