Re: FOREIGN KEY: difference between NOT DEFERRABLE and

On Tue, 4 Sep 2001, Gabriel Fernandez wrote:

> Hi,
>
> What's the difference between NOT DEFERRABLE and INITIALLY IMMEDIATE for
> a FOREIGN KEY specification ?
>
> It seems they are both defining the same: the moment the constraint will
> be checked: the instant the statement is processed or the end of
> transaction.

Well, at start.  With initially immediate you can use SET CONSTRAINTS to
change it on the fly back and forth from deferrable to not.  NOT
DEFERRABLE means you cannot do so.