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 1tt4pO-008L7q-N7 for pgsql-hackers@arkaria.postgresql.org; Fri, 14 Mar 2025 13:11:54 +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 1tt4pN-00702n-2v for pgsql-hackers@arkaria.postgresql.org; Fri, 14 Mar 2025 13:11:53 +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.94.2) (envelope-from ) id 1tt4pM-00702f-Mz for pgsql-hackers@lists.postgresql.org; Fri, 14 Mar 2025 13:11:52 +0000 Received: from fout-b8-smtp.messagingengine.com ([202.12.124.151]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tt4pH-002pzq-2h for pgsql-hackers@lists.postgresql.org; Fri, 14 Mar 2025 13:11:51 +0000 Received: from phl-compute-03.internal (phl-compute-03.phl.internal [10.202.2.43]) by mailfout.stl.internal (Postfix) with ESMTP id 4111C1140108; Fri, 14 Mar 2025 09:11:47 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-03.internal (MEProxy); Fri, 14 Mar 2025 09:11:47 -0400 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=1741957907; x=1742044307; bh=h Eg7e4Gov+R6KhcYc2UEGV8C3Ug8UEEXx0+XGH0Lm7Y=; b=R+WpLE5D6uWSRieVe SfOgAODyW7Qh9JTLHPsMA7UFSfzgo9gEpEU8aKDn5L4mGvjvL3T35vKI/OoYvrSP 5rRX7MwuggJg2Ad5R4sJIRAnQaep/oqXZVwimYS01FyIYu08p9xbLBfkgtEaR0+B c2v+a2PIOSIlxa55zidL9y9EZy3B4qtG24R2uT01b+LjFvLU2BwX8+oVESLzga5n KKmsAeumISOoKCIseskdsnMq89aw7zn2Fk7+DgB4sRZd/4cza8zWXB69wNJ+iyEf +0ZRdtUD85MLq/VgdrDB3ZXHgJnlHXrxL/m6FDVNZuKpgTYaj6ljaBtg6sspFHd3 kAD6g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddufedtledvucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurhepfffhvfevuffkgggtugfgjgesthekredttddt jeenucfhrhhomheplmhlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlh hvhhdrnhhoqdhiphdrohhrgheqnecuggftrfgrthhtvghrnhepiedvjedvieeludeukeek geegudeutdekvdfhtdejgfeugeelgfeiheekieejueeunecuffhomhgrihhnpegvnhhtvg hrphhrihhsvggusgdrtghomhdpthifihhtthgvrhdrtghomhenucevlhhushhtvghrufhi iigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrd hnohdqihhprdhorhhgpdhnsggprhgtphhtthhopeehpdhmohguvgepshhmthhpohhuthdp rhgtphhtthhopehpvghtvghrsegvihhsvghnthhrrghuthdrohhrghdprhgtphhtthhope hnrghthhgrnhgusghoshhsrghrthesghhmrghilhdrtghomhdprhgtphhtthhopehsuhhl rghmuhhlsehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghrsh eslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgpdhrtghpthhtohepthhglhesshhs shdrphhghhdrphgrrdhush X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 14 Mar 2025 09:11:46 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1741951003; bh=LAl7vwxvBYfapmZ8r+3aigOopFPWuECy+V+KV+yMNko=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=iynY0KtfbawZAnP6RAvK01Hy+vT1SRDk+u4LfAY0lsz1+W9q8/Yk1EhwQ3NG/1jo9 DKcX5maTaCGhFu4TZW/L40lQ8cABgH1Hw58qt+WWj7nLe0YftVvp+XO0g54BYscqE7 BXnxbeKUbBBfXv/zLJ+h6g8RCOLz8Om8Pij4dL4fqpVr7q6+gR8C7U+ZGZWsOJJD/2 XbSMnP28mEEmJG45KmoKPNRMt8ceUEifpIaBHmXXn1UIB/1jptU0iM1f17EODMGTV+ Mz1S58pMnbKGX5dBISsklHV0kSV7huBdEcNJYfssZFyQMTz/vq8bKw/miOGBGN3KT8 Sy+wrxrHRV+Ig== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 93BC287; Fri, 14 Mar 2025 12:16:43 +0100 (CET) Date: Fri, 14 Mar 2025 12:16:43 +0100 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Amul Sul Cc: Tom Lane , Pg Hackers , Peter Eisentraut , Nathan Bossart Subject: Re: bogus error message for ALTER TABLE ALTER CONSTRAINT Message-ID: <202503141116.4dt3o344svkd@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-Mar-11, Amul Sul wrote: > I was thinking of something like the attached, which includes your > test cases from 0001. Perhaps the macro name could be improved. FWIW I like this general idea. I don't like the proposed names much though, especially the abuse of ALL_CAPS; and because they operate on the given bits themselves rather than the output of processCASbits(), I would have these checks before doing anything else. (Also, for nicer code layout I would perhaps make the macros static inline functions.) I'm going to stay away from this for a bit, as I think this is of somewhat secondary importance. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "Every machine is a smoke machine if you operate it wrong enough." https://twitter.com/libseybieda/status/1541673325781196801