Feedback-ID: ia2694551:Fastmail
Date: Thu, 6 Feb 2025 13:32:02 +0100
From: =?utf-8?Q?=C3=81lvaro?= Herrera <alvherre@alvh.no-ip.org>
To: Pierre-Paul Hackens <pierre-paul@geopostcodes.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: pg_get_constraintdef throws SQL Error [XX000]: ERROR: invalid
 constraint type "n" (PG17)
Message-ID: <202502061232.fmihjvhn7k3l@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAJd6cTJRYd7uimJkkSSNd-XZx3YH5kRShYRiRaxcgT9i=cxFcg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/202502061232.fmihjvhn7k3l%40alvherre.pgsql>
Precedence: bulk

On 2025-Feb-06, Pierre-Paul Hackens wrote:

> Dear support team,
> 
> I am writing to report a bug I encountered with the pg_get_constraintdef
> function:

> SELECT *, pg_get_constraintdef(oid)
> FROM pg_constraint
> WHERE contype = 'n';
> 
> SQL Error [XX000]: ERROR: invalid constraint type "n"

Hello, thanks for reporting this.  It was reported previously and
already fixed; the fix will be in 17.3, to be released next week.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/