Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit
Date
Msg-id CAKFQuwb55RLaEcFZPKAtHfVaPQO6c-x-ZjgEh5spFnkjwfC6vg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit  (Roman Garcia <yzerno@gmail.com>)
Responses Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit
List 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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored
Next
From: "David E. Wheeler"
Date:
Subject: Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored