Re: [GENERAL] The difference between RESTRICT and NO ACTION

2009-01-26 Thread Tom Lane
Bill Todd writes: > In discussing foreign key constraints the manual makes the following > statement about the difference between RESTRICT and NO ACTION. > "(The essential difference between these two choices is that |NO ACTION| > allows the check to be deferred until later in the transaction,

Re: [GENERAL] The difference between RESTRICT and NO ACTION

2009-01-26 Thread Bill Todd
Bill Todd wrote: In discussing foreign key constraints the manual makes the following statement about the difference between RESTRICT and NO ACTION. "(The essential difference between these two choices is that |NO ACTION| allows the check to be deferred until later in the transaction, whereas

[GENERAL] The difference between RESTRICT and NO ACTION

2009-01-26 Thread Bill Todd
In discussing foreign key constraints the manual makes the following statement about the difference between RESTRICT and NO ACTION. "(The essential difference between these two choices is that |NO ACTION| allows the check to be deferred until later in the transaction, whereas |RESTRICT| does n