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 по дате отправления
От: Scott Marlowe
Дата:
От: Bill Todd
Дата:
FAQ