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 1w75N9-004wiq-2L for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 05:41:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w75N8-001Qcj-0Q for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Mar 2026 05:41:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w75N7-001QcT-29 for pgsql-hackers@lists.postgresql.org; Mon, 30 Mar 2026 05:41:10 +0000 Received: from mail-ot1-x333.google.com ([2607:f8b0:4864:20::333]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w75N0-00000001ktO-1hWH for pgsql-hackers@postgresql.org; Mon, 30 Mar 2026 05:41:09 +0000 Received: by mail-ot1-x333.google.com with SMTP id 46e09a7af769-7d77b179b52so4027710a34.2 for ; Sun, 29 Mar 2026 22:41:02 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774849261; cv=none; d=google.com; s=arc-20240605; b=Vyt+7qeafWruKA/pR+nEHuCV79XiX5hV0L5xJ7grO6PiC6LaaImWENxysm0sTut1Ao C+z72A9gWcfWIWHWrWdjWLVZ+lVlZ8AadKtrIyfadxO0CDfzgxQVqbJX690gWKkix/BS h4ft77IXcBD2947XiEZ3GlyFrvXOLWVmOb69vtUDHzj9V8SD3Y1yC97MoiZFuwaTS51i i235LYfFiHk4nOy2jUDGcW8OSTwabTNF6yAz7mp42qKn8ho27gDYuJYku6OST3PXsrZJ XEiWSse6h/emGI4W4TIc3Fn7M682UYus47WcNBDgHkGs8Z1am+MMbbJxIbaExmmFxDEb UQkA== 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=vMtxaeFdpVwY4no2axftkSKW/JAciL+rmFn1QMdVtjo=; fh=eLlHHukhOAkV6fRvA+QHempXrf+afsViNG2YcCtsl8U=; b=c+kP99GX2Hzxntjs1OeyKkrvtZbqj8diOYUu5JQXNT0Dt1MMPe9OxkFJG9zAjqExzu 9xOY/zXCAJIlRnyKVGpUqau50s0IDIHhl0obZ5sL7V2c4KZzYJqchuHqauMmOWX4a1/D NuYpu3LVd9AFMjbyfZtCBK9dbPAOcpA6wm9WDrpY3CguE4X5+iXfbhsENsCA0mHmeLuV AkUljgh979xdxNqTwB9gdIJLSYYiKDS7s1EBkbRzBwwQVO9cU1shl7T644a5oTjPxjPq H5fri0HKeRwkkvbCpIbQQGWhVofFzXMTdeSRZImPdVEa4yyImm1014SFtAyg4EPysaTR qOIg==; 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=1774849261; x=1775454061; 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=vMtxaeFdpVwY4no2axftkSKW/JAciL+rmFn1QMdVtjo=; b=TEm5eNFVGZC+de/gthkmZmex+Gp/5u0IbNFqiMTMZWeKRV0HNSN3I+jndNSH0A0Tin ysUaLtgJWzvN7wO+fmLfzdh/7Jwd0rYd6SKEQsVBpRg5jUr9Rh7BI2p6SrEYy8lnaQGa SlIa7eiFyxZ7B7jbeiGd1ySXpBSOix6yxa3m3jgwRjQ+/553Y1CF59kH+X3kAu48qED4 eH30U6R53B0elUxljpjgUiMFoCEZ2tIc5o/OiUTTGMS0vJNaa1+sztWGJtF3KIfRmbnp EwyP/HkLBVLapG4plrNItDCL/BfX3jftgvEeV7OaWsBnjNq/MsfUVKVVD8aJOGRs7dfS ao6A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774849261; x=1775454061; 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=vMtxaeFdpVwY4no2axftkSKW/JAciL+rmFn1QMdVtjo=; b=VgraISIB4EF0hortEyUIuuCf5JgJfL4lp76h93e6EglDJ9iGzQkPoLazphmwmicn4k C3DuGnaM99wcsMXF2sGSbWmVjygmefWDAMmaZG1c8Uwhy60wiAI58JPnVnR4ODtWwqTV ZAMQn4gg7PnQWT1p8iktDc2fu7k3HaSeLkkn+5BeaMjBsipSkW/a7JCGljbDerNLpMUR pcyhaQdK43ObHbZwdiFqhRacKyYVkUU7CV7r4jolX7wu2D+kUjC3U/490yKXusQ4NyqI bHce8+8NpP0ME1fYTOBqr7/z1VZIVtNScJ+i1QBxmKKtsk4EbWCnjHaBH2uqabf6jGLL iAsg== X-Gm-Message-State: AOJu0YzX+/eyVdYaTLSK0+qwjTVlcV54I/IBAcg1LGximEet/1PiM10y K5Ruv/9irXEEyKS3EeqLN7Qt7MEkJr04mF6a1Rzp0r+poBOpZxnDEJbA2laQ32kTd+hcBVp1szZ MagIxTMiDkxafImD4WhLuEQ0hoFGfjOY= X-Gm-Gg: ATEYQzwGtdKteLkM4aZclnNpghP4K1hAM4luWz+f89M35nYXBCWGDPyw8qoW0aaiRUq SrevbqmHuGeJKGtQJjfrVA9oBvSVhwlgSJT6xXFs9HzqlXIh91RqXp2QKWUIurqsoTCEO3cESHU YVnYqwWKzKp8tedOhWGyu6I14b/7gMH2gzlz8iA+pCRSFZiquQ10in2A6xtZ4eZuzaq0sl1tHDh Hh1fYAuwWtHxYQBIkY93mCrIFLWgUGGED6rNpIMk21jwZuQX5DLlguuKChnoVDhZ/exbhdfniJY QYfhKACcJByqbUUKf84nEOqttZZEChID7pwPvqAotk0N8AE9n/9p X-Received: by 2002:a05:6820:2916:b0:67e:33b3:dd14 with SMTP id 006d021491bc7-67e33b3ddc3mr1047512eaf.67.1774849261617; Sun, 29 Mar 2026 22:41:01 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Fujii Masao Date: Mon, 30 Mar 2026 14:40:49 +0900 X-Gm-Features: AQROBzBVhu5sGkM8xhcHJFEJwH2tEoRuXK_lDuppdF_14A4BFGygmIkNQzMlWMc Message-ID: Subject: Re: [PATCH] Fix unexpected loss of DEFERRABLE property after toggling NOT ENFORCED / ENFORCED To: Yasuo Honda 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 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, where > NOT ENFORCED foreign keys were introduced. I've pushed the patch. Thanks! Regards, --=20 Fujii Masao