Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit
Дата
Msg-id CAKFQuwb55RLaEcFZPKAtHfVaPQO6c-x-ZjgEh5spFnkjwfC6vg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit  (Roman Garcia <yzerno@gmail.com>)
Ответы Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-bugs
Дерево обсуждения
On Thu, Nov 24, 2022 at 10:12 AM Roman Garcia <yzerno@gmail.com> wrote:
Maybe I should have created this report as a possible evolution then ? As I understand it, the whole point of deferrable initially deferred is for it to be checked at transaction commit, not just for insert/update/delete, but as a general concept for the constraint.


I don't see any benefit for the effort making it work for DDL.  How exactly were you expecting to benefit from having the constraint deferred during the transaction in which you created it?

But maybe you have a suggestion for the documentation to make this distinction more clear?

David J.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored
Следующее
От: "David E. Wheeler"
Дата:
Сообщение: Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored