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.
