pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

pg_get_constraintdef throws SQL Error [XX000]: ERROR: invalid constraint type "n" (PG17)
2+ messages / 2 participants
[nested] [flat]

* pg_get_constraintdef throws SQL Error [XX000]: ERROR: invalid constraint type "n" (PG17)
@ 2025-02-06 10:10  Pierre-Paul Hackens <pierre-paul@geopostcodes.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Pierre-Paul Hackens @ 2025-02-06 10:10 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org

Dear support team,

I am writing to report a bug I encountered with the pg_get_constraintdef
function:

CREATE DOMAIN not_null AS TEXT NOT NULL;


CREATE TABLE a (

col not_null

);


SELECT *, pg_get_constraintdef(oid)

FROM pg_constraint

WHERE contype = 'n';


SQL Error [XX000]: ERROR: invalid constraint type "n"


In PG 16 it was ok.
Thank you for your attention to this matter.

Sincerely,
Pierre-Paul

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: pg_get_constraintdef throws SQL Error [XX000]: ERROR: invalid constraint type "n" (PG17)
@ 2025-02-06 12:32  Álvaro Herrera <alvherre@alvh.no-ip.org>
  parent: Pierre-Paul Hackens <pierre-paul@geopostcodes.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Álvaro Herrera @ 2025-02-06 12:32 UTC (permalink / raw)
  To: Pierre-Paul Hackens <pierre-paul@geopostcodes.com>; +Cc: pgsql-bugs@lists.postgresql.org

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/





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2025-02-06 12:32 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-06 10:10 pg_get_constraintdef throws SQL Error [XX000]: ERROR: invalid constraint type "n" (PG17) Pierre-Paul Hackens <pierre-paul@geopostcodes.com>
2025-02-06 12:32 ` Álvaro Herrera <alvherre@alvh.no-ip.org>

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