From: Álvaro 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)
Date: Thu, 6 Feb 2025 13:32:02 +0100
Message-ID: <202502061232.fmihjvhn7k3l@alvherre.pgsql> (raw)
In-Reply-To: <CAJd6cTJRYd7uimJkkSSNd-XZx3YH5kRShYRiRaxcgT9i=cxFcg@mail.gmail.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: alvherre@alvh.no-ip.org, pierre-paul@geopostcodes.com, pgsql-bugs@lists.postgresql.org
Subject: Re: pg_get_constraintdef throws SQL Error [XX000]: ERROR: invalid constraint type "n" (PG17)
In-Reply-To: <202502061232.fmihjvhn7k3l@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox