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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Roman Garcia <yzerno(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit
Date: 2022-11-24 17:22:56
Message-ID: CAKFQuwb55RLaEcFZPKAtHfVaPQO6c-x-ZjgEh5spFnkjwfC6vg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Nov 24, 2022 at 10:12 AM Roman Garcia <yzerno(at)gmail(dot)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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David E. Wheeler 2022-11-24 17:26:58 Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored
Previous Message David G. Johnston 2022-11-24 17:16:35 Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored