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 1tLlc0-00GsDx-NO for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Dec 2024 16:00:25 +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 1tLlbx-00DFTr-GC for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Dec 2024 16:00:22 +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 1tLlbw-00DFTi-KY for pgsql-bugs@lists.postgresql.org; Thu, 12 Dec 2024 16:00:22 +0000 Received: from fout-b2-smtp.messagingengine.com ([202.12.124.145]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tLlbr-002UIR-Pf for pgsql-bugs@lists.postgresql.org; Thu, 12 Dec 2024 16:00:21 +0000 Received: from phl-compute-06.internal (phl-compute-06.phl.internal [10.202.2.46]) by mailfout.stl.internal (Postfix) with ESMTP id B5EA3114024D; Thu, 12 Dec 2024 11:00:13 -0500 (EST) Received: from phl-imap-10 ([10.202.2.85]) by phl-compute-06.internal (MEProxy); Thu, 12 Dec 2024 11:00:13 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= zzzcomputing.com; h=cc:cc:content-transfer-encoding:content-type :content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to; s=fm1; t=1734019213; x=1734105613; bh=aYJLEF+wryH/OouhIM+kV E6YZbaBfq5WE70kTyyaLck=; b=ajAIbLpvkYlQa0c9gt1mNy0yPCu2HIqvNpyOy n5OGyAUX/sHlZui43KuOh4VOvWT6Qk1wXRkA4nqzyKTpsT+OHzsWT0HrwvDLKxGq wyARsLRZjqE5FH02Y1DzGXCG7+v4xlGVn4dye3s8Jr3BbgD5erFg53QjYnBGjVQG ZXJrhx2tluGmR1CwsBgAczzQ3CMWHqXIfi2RJk1Wzk39TCdx+0pbAlr62EyDAccN W6imMIEiDicZPPP4iFl3bh2Mk6BTn3KtXTS/mrou4ID/bKromihzCxLo/jNySSKE P2M0GbyDjHzbMR42YPWpKIe5KKpK6MMmoWj0opMD9+MSgNb5w== 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 :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1734019213; x= 1734105613; bh=aYJLEF+wryH/OouhIM+kVE6YZbaBfq5WE70kTyyaLck=; b=3 1hz2QNe70PCfLqdO78ZK/naAzjYQqPXW9seujeOsdrYv2jlgQwDeobn+Y7bO0PoO sF93wMijpzVpNm4Z/uyv3ADNtIs8Ndx/H3hHCifAVH+haS+nL8Yn3sVrTt+0i5rB nkVtDu+czQTQbWlpyU965088CtW0ryyiwLBh3NgpI2SGucwjaOYA2axDkn6IaByI c5VwmEZFUlXQSMU96sTvK+vS0velmr4dsN1aXQF+7jBZPAXkyQ+3s6BijOdi4CWk yUtKwZR7BBccZbAACqtctRcoXS/1ogJXWYEPrPRLN9X7zAJu0j730JoP6qYeLFfJ 0Mni/VWoflaeuu/FxB6sg== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrkeehgdekudcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdpuffr tefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnth hsucdlqddutddtmdenucfjughrpefoggffhffvvefkjghfufgtgfesthejredtredttden ucfhrhhomhepfdfoihhkvgcuuegrhigvrhdfuceomhhikhgvpghmphesiiiiiigtohhmph huthhinhhgrdgtohhmqeenucggtffrrghtthgvrhhnpedtffffueejleetgeefvdfgfffh vdeuudffudeghedttddugeeugfekledvjedvffenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihhkvggpmhhpseiiiiiitghomhhpuhhtihhn ghdrtghomhdpnhgspghrtghpthhtohepfedpmhhouggvpehsmhhtphhouhhtpdhrtghpth htohepuggrvhhiugdrghdrjhhohhhnshhtohhnsehgmhgrihhlrdgtohhmpdhrtghpthht ohepphhgshhqlhdqsghughhssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrghdprh gtphhtthhopehtghhlsehsshhsrdhpghhhrdhprgdruhhs X-ME-Proxy: Feedback-ID: i1c194411:Fastmail Received: by mailuser.phl.internal (Postfix, from userid 501) id D2CC73C006B; Thu, 12 Dec 2024 11:00:10 -0500 (EST) X-Mailer: MessagingEngine.com Webmail Interface MIME-Version: 1.0 Date: Thu, 12 Dec 2024 10:59:49 -0500 From: "Mike Bayer" To: "Tom Lane" Cc: "David G. Johnston" , "pgsql-bugs@lists.postgresql.org" Message-Id: In-Reply-To: <652291.1734018520@sss.pgh.pa.us> References: <652291.1734018520@sss.pgh.pa.us> Subject: Re: invalid constraint type "n" when using pg_catalog.pg_get_constraintdef() on pg17, regression from pg16 Content-Type: text/plain Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Dec 12, 2024, at 10:48 AM, Tom Lane wrote: > "Mike Bayer" writes: >> correct, this is observed using all Python postgresql drivers, I was using psql to make an easy repro > > As Jian said, this was reported and fixed last month. > (I checked that your example works against v17 branch tip.) > Should appear in 17.3. > > regards, tom lane thanks for double checking! - mike