Re: Fix failing assert in deferred constraint trigger

From: Fabrizio Mello <fabrizio(at)planetscale(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Fix failing assert in deferred constraint trigger
Date: 2026-09-11 13:43:33
Message-ID: CABo-N97TspKD_QX6WKdtCYfezUi=g8yamHYyDDeE_LpoJLgDjQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Sep 10, 2026 at 10:44 PM Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>
> On Wed, Sep 9, 2026 at 12:51 PM Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> > One comment: isn't it be better to add a test for exception handling
> > in a deferred constraint trigger at COMMIT? For example, in triggers.sql:
>
> I've added this test. Attached is the updated version of the patch.
>

Thanks

> BTW, I found that Patrick Reynolds <patrick(at)piki(dot)org> is listed in the
> From field of the patch. Does that mean he is the author of the patch,
> rather than you? I'm just asking because I need to know who to list in the
> Author tag of the commit message.
>

Yes he is the original author of the patch, which he worked on
internally at PlanetScale. If you don't mind, please use
piki(at)planetscale(dot)com in the commit message.

Regards,

--
Fabrízio Mello
PlanetScale Postgres Core Team

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabrizio Mello 2026-09-11 13:48:32 Re: Fix failing assert in deferred constraint trigger
Previous Message Vik Fearing 2026-09-11 13:35:57 Logical Implication