Re: BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same
Дата
Msg-id 18397.1281104068@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same  ("Frank Heikens" <f.heikens@anva.nl>)
Ответы Re: BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same  (Frank Heikens <f.heikens@anva.nl>)
Список pgsql-bugs
Дерево обсуждения 
"Frank Heikens" <f.heikens@anva.nl> writes:
> Description:        DEFERRABLE and  DEFERRABLE INITIALLY DEFERRED are the
> same

This test proves no such thing.  You are supposing that a deferrable
unique index has the exact same behavior as a nondeferrable one.
Actually, a DEFERRABLE IMMEDIATE index enforces its checks as of the end
of the statement, which is per spec.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Frank Heikens"
Дата:
Сообщение: BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same
Следующее
От: "Marcelo Mas"
Дата:
Сообщение: BUG #5607: memmory leak in ecpg