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.94.2) (envelope-from ) id 1tnbuu-006kMm-Ss for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Feb 2025 11:19:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tnbut-00CHY2-Jk for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Feb 2025 11:18:59 +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.94.2) (envelope-from ) id 1tnbus-00CHXu-Sk for pgsql-hackers@lists.postgresql.org; Thu, 27 Feb 2025 11:18:59 +0000 Received: from fhigh-a2-smtp.messagingengine.com ([103.168.172.153]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tnbup-000Mor-1Y for pgsql-hackers@postgresql.org; Thu, 27 Feb 2025 11:18:57 +0000 Received: from phl-compute-08.internal (phl-compute-08.phl.internal [10.202.2.48]) by mailfhigh.phl.internal (Postfix) with ESMTP id 80CFB11404FE; Thu, 27 Feb 2025 06:18:55 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-08.internal (MEProxy); Thu, 27 Feb 2025 06:18:55 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1740655135; x=1740741535; bh=C BuX7yTYgMXTo3i16GVIXGNZdIbMilw39IWjqLzhnkk=; b=ZM1jOwO5+k55euQ3i wYYEqZMnliD//zk7KETkSGQwlrleQOnrKsCss/jWijuyvkxoxwINLl9DOckq8PJy VZZycJYtlgfoVStgWBG1b3usVZOyr2WRHgS5BaUuz1t4ZR37s/LtfiaalknuagEf 63oYbpy35paIb5oIaI2JtY+ovSTb3SgUE8ysDrl51F9XO1+tV4RjVtQ+WnL11Y6T /X4lZjPcJpLKB1KyA4R+zhV7omN46r+6SaiGbbBng9oHt2VBJaRgVioiKKzyLjzH rky4i18i441yi8sSOWKy3bcY+sIs5RZZ9e7KtCVKCsj9uNYH8Of5WeCMdT1J3NvT LfA1w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdekjeeffecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpeffhffvvefukfggtggugfgjsehtkeertddttdej necuhfhrohhmpemllhhvrghrohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvh hhrdhnohdqihhprdhorhhgqeenucggtffrrghtthgvrhhnpedvheeuffehgfeukeeufeeh hefghfeugfefudekjeevudffgeffkeegffffveegheenucffohhmrghinhepvghnthgvrh hprhhishgvuggsrdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehm rghilhhfrhhomheprghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrghdpnhgspg hrtghpthhtohepjedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepjhhovghlsegt ohhmphhilhgvrhdrohhrghdprhgtphhtthhopehpvghtvghrsegvihhsvghnthhrrghuth drohhrghdprhgtphhtthhopehsuhhrrghjrdhkhhgrrhgrghgvsegvnhhtvghrphhrihhs vggusgdrtghomhdprhgtphhtthhopegrshhhuhhtohhshhdrsggrphgrthdrohhsshesgh hmrghilhdrtghomhdprhgtphhtthhopehjihgrnhdruhhnihhvvghrshgrlhhithihsehg mhgrihhlrdgtohhmpdhrtghpthhtohepshhulhgrmhhulhesghhmrghilhdrtghomhdprh gtphhtthhopehpghhsqhhlqdhhrggtkhgvrhhssehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 27 Feb 2025 06:18:54 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1740655131; bh=tXy6OtzXI5g7SZbYPnaL6nsde3FO4/gKagonLvw6uj8=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=dg+5Vw0DCx77K4Yt3Nyhcl1b2sdwWPmf7+ytAcXMJcNCtByLuI2pBs6riVRbZ6J8c KjEzYd1M/6oqNWw5hoeIH2SLADNPSW0ROgYk+P4Ca9EhNOzvRav0t7ixvgo8KVtY6h ReZBwiDKOeNJ4vmD9FidXY1UNXHIJZnX9nwa2Y/pTscVm0ZqA1inADiIopEvAGhBm2 O0yqZfub2ZgUAa5v3UNEH1osniKW+5dwRWjL5fACOrEma8OsmaHIv+wqOyoHJf7ei6 RcrKP+oRwlQOVfLldmH2Q8LVJO0R5yOevSi7XfgZSEKe9L7Pwc8DE5R3j5DkT+HrPj zJeou5zZ0SVbA== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 3F72B8F; Thu, 27 Feb 2025 12:18:51 +0100 (CET) Date: Thu, 27 Feb 2025 12:18:51 +0100 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Amul Sul Cc: Peter Eisentraut , Ashutosh Bapat , jian he , PostgreSQL-development , Joel Jacobson , Suraj Kharage Subject: Re: NOT ENFORCED constraint feature Message-ID: <202502271118.3jopzlc5yfkn@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Feb-27, Amul Sul wrote: > Attached is the rebased patch set against the latest master head, > which also includes a *new* refactoring patch (0001). In this patch, > I’ve re-added ATExecAlterChildConstr(), which is required for the main > feature patch (0008) to handle recursion from different places while > altering enforceability. I think you refer to ATExecAlterConstrEnforceability, which claims (falsely) that it is a subroutine to ATExecAlterConstrRecurse; in reality it is called from ATExecAlterConstraintInternal or at least that's what I see in your 0008. So I wonder if you haven't confused yourself here. If nothing else, that comments needs fixed. I didn't review these patches. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ "Porque francamente, si para saber manejarse a uno mismo hubiera que rendir examen... ¿Quién es el machito que tendría carnet?" (Mafalda)