Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w7BZC-0052rZ-0J for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 12:18:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7BZA-0038c9-22 for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 12:18:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w7BZA-0038c1-13 for pgsql-hackers@lists.postgresql.org; Mon, 30 Mar 2026 12:18:00 +0000 Received: from mail-pg1-x530.google.com ([2607:f8b0:4864:20::530]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7BZ8-00000001zSP-10ap for pgsql-hackers@postgresql.org; Mon, 30 Mar 2026 12:18:00 +0000 Received: by mail-pg1-x530.google.com with SMTP id 41be03b00d2f7-c7382963b67so235706a12.0 for ; Mon, 30 Mar 2026 05:17:58 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774873076; cv=none; d=google.com; s=arc-20240605; b=YEFxkHJDIYZsyZMKxq7kq/Mc8tiR7p0p5dWml/r0HsWdYw4xihbQaMTJtwABk90SX1 ajQlbR8IIjNO4Jeg5D5S5IS7GTIAQAy3gWUG5p9H3QGOSgYJi3L4+ym9vQ3QoCxAsEAp aCKl6jY4TTbQNU15bUSfocrV5LMAxZrg3q8bHEe3iPTiVovw7AtFRLH8QFOX/OaZ6nz/ BRgRPdsCuFiuPM2qDbI8Y5OigXTAx2+Czb9gpR1LxhCMIWmCEWMynjdo+ce15/c0Jx6n Pcti+tQ9yrGJ46SKgQqgZoVK4EbVxVoe5MBHOmINGD18PHs96L+u/ZzLPKQTC+WPOIdR AmlQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=R5obOSegEDnmrcqeEeUz/UuQt864bPEwZLU49wUqOjo=; fh=F0QZqiEmFa4epNcEdb4BNAvTdz0HCUNYQdfDC90PlI8=; b=HbZ5Z7tXRV9Vu+ducBMiiwAF75vK2gQRPmGNaV4G9Vd/XpiuJkuUbXH8IwUx8U+xXg w+7IzsfIZCPIG7NxnrkxHA00wksM+2Z75aW0I65fi5DOCei1t+s6trdNfZ8TRs/++GNf CK4XRxbLRIstRIs2bfHnOKEdRHY2o0QXlGL50SsMJHUVzQhjL/o8LDfpVhiLgt52iYX7 FSKr1/KW9v8OPuMZR83N0QsS/dIRbUO9yBi8qRaHDcNnaDJBj3nrTJqTc8OYZWSvnqRO jf20Usgsqo4AW9yGty/gDGuSkhSKzanZzGMv9rEUYtD13Do5csG5UjSrnOGGHvPW0NKz EDLA==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774873076; x=1775477876; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=R5obOSegEDnmrcqeEeUz/UuQt864bPEwZLU49wUqOjo=; b=GoKs1eOwvYCn85kqUk9fENBxqC3/CIbqzooYAVjehtNrZtKmWd4va3U9FZqFeLedXD RZKYSKGoc9AQaz3I1PjlXKj+woB4bZfDWoGpmsitQhFX6VHkQ7x5NELcaNLqvBSIOGhk td5OJgoc/iQESnz2n36ehHtb7vZgg9i/A6+4y3EGBnrmJfr2nbxGWnCJIS4/MF70n7gn BXGmkwwYMhqB+BVnGt0x2bnOIURlSAQaj/WTm/cUJe5nAuXPtoqxtDju3Nga+aaN7L5p gl6iYzZPhJXrgc3RV0A4ItOAVb7jIeMm5HTC/E/E+3t786WexuKwNaVLTQ3vpcnEmjt/ /6TA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774873076; x=1775477876; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=R5obOSegEDnmrcqeEeUz/UuQt864bPEwZLU49wUqOjo=; b=JF7tc8pkW6qX8AtuXbkMaFIa3CnCyfIcLzso0Vfo2+VZCxRi19VEH4w+u8TrevYnp6 bzihggQnoufoo2Zob/JEXETnzHKyMdp8m+8dCY4mmLaNrD8Mg6GHQWhVq1kgm9y8XxWX cdyj+T//v70X0lzTrm6dWt0xwurww9hNFGk6UqK/i5rR9hMPDqBjh7bazsU6VMJYBsDI +0WO1l00JEV1/ZlaR9FiE1oW5wIOSphv3pNgjWULNGDk97BjUV6s21jo2sWXNJmm/0IO 8EkOV7M28PO0GZAowO0JgR5UIBbCbskAln6/fVM0Cq8dVvBeebmkDFF7s2ovywk3tASB POGQ== X-Gm-Message-State: AOJu0Yzg/5xax+6SRk0SA3GkpOh6DM7tDerD8lJbqhD2WAx9M2ANncLL t459niFJThtXNQXPN+xVZSfzUr2AbiPkTa6vWLDtdsZXR+UVZVE2DspG74c4gBwxyLsPxRGOdSa 40SquNbnHyF7H0EhoeZGcp8p2XAUbY6E= X-Gm-Gg: ATEYQzz4ai5Lw8Y8xh3TQsp5KttSY7880p6oKM1/cJwgtrIf7YVCQlNx/Na//mY9kBd DNBvP83GblwqtUOQTRiqLaZRQznc5jcnjTAGMP38zsGFQK12Xchvlc41kEUMD3Rq332Fa9SoObk GXZeCpPRkR+XlBBqGngesG2PUw4jAul2NeMDtnGMnb+yIlhP0v7qKbVZ4a39Zpa41B/s4twd0aN pNPQ9hJxJWZwgHgpjjoFHq5kvWS5P4H+yl3VRQRBkSPoYS28pAGubiV1ZfCykiaxcgtcHE6/fNC 9bdKicBg5ie1qK9A+Cjv+PyNUAmTCLRJvRW81+mcpWlgzG8W9ayA3g5hvwozPK0= X-Received: by 2002:a17:902:dac2:b0:2b0:ba60:7210 with SMTP id d9443c01a7336-2b0cdc12908mr74451235ad.1.1774873075757; Mon, 30 Mar 2026 05:17:55 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Yasuo Honda Date: Mon, 30 Mar 2026 21:17:44 +0900 X-Gm-Features: AQROBzBGWBB0cRz9RuaWDZ7qXO6B3Y3JPu__5niQNdYThHQwcyWyv6GUJkMX2qw Message-ID: Subject: Re: [PATCH] Fix unexpected loss of DEFERRABLE property after toggling NOT ENFORCED / ENFORCED To: Fujii Masao Cc: PostgreSQL-development Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > 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=E2=80=AFPM Fujii Masao = wrote: > > On Sat, Mar 28, 2026 at 12:01=E2=80=AFAM Fujii Masao wrote: > > Barring any objections, I will commit this and backpatch it to v18, whe= re > > NOT ENFORCED foreign keys were introduced. > > I've pushed the patch. Thanks! > > Regards, > > -- > Fujii Masao