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 1tLkbG-00GkpI-QZ for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Dec 2024 14:55:35 +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 1tLkbE-00CbE8-6p for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Dec 2024 14:55:33 +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 1tLkbD-00CbE0-Lh for pgsql-bugs@lists.postgresql.org; Thu, 12 Dec 2024 14:55:33 +0000 Received: from fhigh-b3-smtp.messagingengine.com ([202.12.124.154]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tLkbC-002Snu-8D for pgsql-bugs@lists.postgresql.org; Thu, 12 Dec 2024 14:55:31 +0000 Received: from phl-compute-06.internal (phl-compute-06.phl.internal [10.202.2.46]) by mailfhigh.stl.internal (Postfix) with ESMTP id 4325D2540270; Thu, 12 Dec 2024 09:55:29 -0500 (EST) Received: from phl-imap-10 ([10.202.2.85]) by phl-compute-06.internal (MEProxy); Thu, 12 Dec 2024 09:55:29 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= zzzcomputing.com; h=cc:cc: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=1734015329; x=1734101729; bh=+D8r98guHakAin1qyFVxE+U1nGHTSMrzVyCcBm789sQ=; b= EQ4pUgumtj7iVxaPJtvZ2m8qBhSbOvFpdpeV3qyAZq0xw3AAHkVUgOSYphvSnQgE arZ2mClaQNsPkNNpYkTB+GXtERm8s7ozgBaaXUxoO/XE/kTRYYV/yGwDKdKbPx9x KOvPpLJw6AoVQbonaIkxJKtt67kvdEHizwKKarmPRvEYTuk3GQ5fIw4CDKKaDlYm IamW1cwAaGMeMEmSFf0eOoTXFvK+1lEpKfXIkxP0kfT2ljTL75d34eTjCEP8U1YF mRUUE6IBCqax43rJLGR6xxxZYYo8Y8/iVzlncgOtjebp3Wv38MgNbm9FZPJaU8Xw HSMcSwWeZjecWO0RDvCnfQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc: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= 1734015329; x=1734101729; bh=+D8r98guHakAin1qyFVxE+U1nGHTSMrzVyC cBm789sQ=; b=uwsGwo0U+lByNwZ/VCtwDFqy6KpO8wYzDh8B9F++xK7vpPD/Yo4 gqNnXEFoS5yU/oqEdRuL175ayxmcmrIzY9pmsJCW5nc7Xt+2gNWkGBmaQpXXKSy8 YemYFPJRJ4bpy96izTiUEt5n06sueaWMooUylbGRnEAq2nQpkuv2P0SUmchwJElX MU113IlP2SfESnMfhAfgYHdNP/UQqWa4sxG3vAhPP8f2vCHdDmpBYPkfQD1Lxolj twvZ0m8io3dPYEyUr2OG+NgOW6REp/JGhCNYwXkT8YySMYkF2iwVyXpqRd+7iY9W Jomcoft4St5Z6O8w44OmjYchWqu1kjO+Pmg== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrkeehgdeilecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdpuffr tefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnth hsucdlqddutddtmdenucfjughrpefoggffhffvvefkjghfufgtsegrtderreertdejnecu hfhrohhmpedfofhikhgvuceurgihvghrfdcuoehmihhkvggpmhhpseiiiiiitghomhhpuh htihhnghdrtghomheqnecuggftrfgrthhtvghrnhepveeivefhuddtudeggfefffeikeeg tdetveeiteevleetfeduheeilefhfeekjeeinecuvehluhhsthgvrhfuihiivgeptdenuc frrghrrghmpehmrghilhhfrhhomhepmhhikhgvpghmphesiiiiiigtohhmphhuthhinhhg rdgtohhmpdhnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpohhuthdprhgtphhtth hopegurghvihgurdhgrdhjohhhnhhsthhonhesghhmrghilhdrtghomhdprhgtphhtthho pehpghhsqhhlqdgsuhhgsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i1c194411:Fastmail Received: by mailuser.phl.internal (Postfix, from userid 501) id 80BC03C0066; Thu, 12 Dec 2024 09:55:28 -0500 (EST) X-Mailer: MessagingEngine.com Webmail Interface MIME-Version: 1.0 Date: Thu, 12 Dec 2024 09:55:08 -0500 From: "Mike Bayer" To: "David G. Johnston" Cc: "pgsql-bugs@lists.postgresql.org" Message-Id: In-Reply-To: References: Subject: Re: invalid constraint type "n" when using pg_catalog.pg_get_constraintdef() on pg17, regression from pg16 Content-Type: multipart/alternative; boundary=d128bdbe03c94296a20dd60ab6c9d929 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --d128bdbe03c94296a20dd60ab6c9d929 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On Thu, Dec 12, 2024, at 9:37 AM, David G. Johnston wrote: > On Thu, Dec 12, 2024 at 7:14=E2=80=AFAM David G. Johnston wrote: >> On Thursday, December 12, 2024, Mike Bayer = wrote: >>>=20 >>> $ psql -U scott -h pg17 test >>> Password for user scott:=20 >>> psql (16.3, server 17.2) >>> WARNING: psql major version 16, server major version 17. >>> Some psql features might not work. >>=20 >> This is apparently just such a feature=E2=80=A6 >>=20 >=20 > My bad, ignore this, I saw this and ended up thinking the complaint wa= s against psql, not the server-internals. >=20 > David J. correct, this is observed using all Python postgresql drivers, I was usi= ng psql to make an easy repro --d128bdbe03c94296a20dd60ab6c9d929 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

= On Thu, Dec 12, 2024, at 9:37 AM, David G. Johnston wrote:
On Thu, Dec 12, 2024 at 7:14=E2=80=AFAM David G. Johns= ton <david.g.johnston@g= mail.com> wrote:
On Thursday, December 12, 2024, Mike Bay= er <mik= e_mp@zzzcomputing.com> wrote:

$ ps= ql -U scott -h pg17 test
Password for user scott:
psql (16.3, server 17.2)
WARNING: psql major ver= sion 16, server major version 17.
      &n= bsp;  Some psql features might not work.

This is apparently just such a feature=E2=80=A6


My bad, ignore t= his, I saw this and ended up thinking the complaint was against psql, no= t the server-internals.

David = J.

correct, t= his is observed using all Python postgresql drivers, I was using psql to= make an easy repro




--d128bdbe03c94296a20dd60ab6c9d929--