Doubts about FK - Mailing list pgsql-sql

From Rafael Domiciano
Subject Doubts about FK
Date
Msg-id 3a0028490809121114v6668639aw5e5f50fcb8525c21@mail.gmail.com
Whole thread Raw
Responses Re: Doubts about FK
List 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

pgsql-sql by date:

Previous
From: "Ruben Gouveia"
Date:
Subject: Re: DIfference between max() and greatest() ?
Next
From: Hengky Lie
Date:
Subject: Re: Pls Hlp: SQL Problem