Re: [PATCH] Fix unexpected loss of DEFERRABLE property after toggling NOT ENFORCED / ENFORCED

Yasuo Honda <yasuo.honda@gmail.com>

From: Yasuo Honda <yasuo.honda@gmail.com>
To: Fujii Masao <masao.fujii@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2026-03-30T12:17:44Z
Lists: pgsql-hackers
> I've pushed the patch. Thanks!

Thanks for reviewing and committing this, and for the fixups.
Once this fix is released, I can complete NOT ENFORCED foreign key
support in Ruby on Rails.

--
Yasuo Honda

On Mon, Mar 30, 2026 at 2:41 PM Fujii Masao <masao.fujii@gmail.com> wrote:
>
> On Sat, Mar 28, 2026 at 12:01 AM Fujii Masao <masao.fujii@gmail.com> wrote:
> > Barring any objections, I will commit this and backpatch it to v18, where
> > NOT ENFORCED foreign keys were introduced.
>
> I've pushed the patch. Thanks!
>
> Regards,
>
> --
> Fujii Masao



Commits

  1. Fix FK triggers losing DEFERRABLE/INITIALLY DEFERRED when marked ENFORCED again