The difference between RESTRICT and NO ACTION
От
Bill Todd
Тема
The difference between RESTRICT and NO ACTION
Дата
Msg-id
497E3C0F.5030003@dbginc.com
Список
Дерево обсуждения
The difference between RESTRICT and NO ACTION Bill Todd <pg@dbginc.com>
Re: The difference between RESTRICT and NO ACTION Tom Lane <tgl@sss.pgh.pa.us>
Re: The difference between RESTRICT and NO ACTION Bill Todd <pg@dbginc.com>
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 not.)" Can someone explain what this means in practical terms? Do both options generate the same error message? Does "until later in the transaction" mean that NO ACTION is not checked until an attempt is made to commit the transaction? If someone can point me to a more detailed explanation I would appreciate it. Thanks. Bill
В списке pgsql-general по дате отправления