Doubts about FK

From: "Rafael Domiciano" <rafael(dot)domiciano(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Doubts about FK
Date: 2008-09-12 18:14:08
Message-ID: 3a0028490809121114v6668639aw5e5f50fcb8525c21@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi there,

In my DB I have a couple of FK, so the change of referenced columns is a
quite complicated.
Today, I DISABLE TRIGGER ALL on the tables envolved and then ENABLE TRIGGER
ALL to back them.

Is there a better way to do that?
I read something about SET CONSTRAINTS ALL DEFFERED, but I don't know how to
use it.

Regards,

Rafael Domiciano

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Hengky Lie 2008-09-12 18:50:46 Re: Pls Hlp: SQL Problem
Previous Message Ruben Gouveia 2008-09-12 16:47:39 Re: DIfference between max() and greatest() ?