| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Roman Garcia <yzerno(at)gmail(dot)com>, 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 22:23:56 |
| Message-ID: | 20221124222356.qolurdwwcnxkbjt2@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 2022-Nov-24, David G. Johnston wrote:
> 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.
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | houzj.fnst@fujitsu.com | 2022-11-25 02:46:46 | RE: Incorrect messages emitted from pgoutput when using column lists |
| Previous Message | David E. Wheeler | 2022-11-24 17:55:25 | Re: BUG #17694: In JSONPath expressions, characters between leading $ and dot appear to be ignored |