From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Mike Bayer" <mike_mp@zzzcomputing.com>
cc: "David G. Johnston" <david.g.johnston@gmail.com>,
        "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: invalid constraint type "n" when using
 pg_catalog.pg_get_constraintdef() on pg17, regression from pg16
In-reply-to: <e4fedac0-3de4-4773-94d3-c391c9e19d63@app.fastmail.com>
References: <a90f53c4-56f3-4b07-aefc-49afdc67dba6@app.fastmail.com>
 <CAKFQuwbfZe4MGKzovK2uYXjKgk9OmS=ufY43_QZ_yESBy-7shg@mail.gmail.com>
 <CAKFQuwbddfm+ni=TJyjHsJOFc86CaUeppUMJZU20bqYkSM2t6Q@mail.gmail.com>
 <e4fedac0-3de4-4773-94d3-c391c9e19d63@app.fastmail.com>
Comments: In-reply-to "Mike Bayer" <mike_mp@zzzcomputing.com>
	message dated "Thu, 12 Dec 2024 09:55:08 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <652290.1734018520.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 12 Dec 2024 10:48:40 -0500
Message-ID: <652291.1734018520@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/652291.1734018520%40sss.pgh.pa.us>
Precedence: bulk

"Mike Bayer" <mike_mp@zzzcomputing.com> writes:
> correct, this is observed using all Python postgresql drivers, I was usi=
ng 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