From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Roman Garcia <yzerno@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit
Date: Thu, 24 Nov 2022 23:23:56 +0100
Message-ID: <20221124222356.qolurdwwcnxkbjt2@alvherre.pgsql> (raw)
In-Reply-To: <CAKFQuwb55RLaEcFZPKAtHfVaPQO6c-x-ZjgEh5spFnkjwfC6vg@mail.gmail.com>
On 2022-Nov-24, David G. Johnston wrote:
> 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.
Yeah ... I agree that this scenario seems rather pointless, but I don't
see any hard argument for making it not work, other than development
effort. If Roman or somebody would like to submit a patch to implement
it, I don't see why we wouldn't accept it (pending review process, ofc).
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"Crear es tan difícil como ser libre" (Elsa Triolet)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: alvherre@alvh.no-ip.org, david.g.johnston@gmail.com, yzerno@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit
In-Reply-To: <20221124222356.qolurdwwcnxkbjt2@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox