Re: pg_get_constraintdef throws SQL Error [XX000]: ERROR: invalid constraint type "n" (PG17)

From: Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Pierre-Paul Hackens <pierre-paul(at)geopostcodes(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: pg_get_constraintdef throws SQL Error [XX000]: ERROR: invalid constraint type "n" (PG17)
Date: 2025-02-06 12:32:02
Message-ID: 202502061232.fmihjvhn7k3l@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Sandeep Thakkar 2025-02-06 13:17:11 Re: BUG #18794: pgBouncer Windows installation error due to a simple sql bug???
Previous Message PG Bug reporting form 2025-02-06 11:47:10 BUG #18799: /src/interfaces/ecpg/pgtypeslib/timestamp.c possible NULL deref