Re: Fix failing assert in deferred constraint trigger

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

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.

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.

Regards,

--
Fujii Masao

Attachment Content-Type Size
v2-0001-Fix-failing-assert-in-deferred-constraint-trigger.patch application/octet-stream 5.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hayato Kuroda (Fujitsu) 2026-09-11 01:51:33 RE: Review items for EXCEPT TABLE publication
Previous Message Chao Li 2026-09-11 01:42:15 Re: REPACK (CONCURRENTLY) fails when replica identity index is dropped