Request a Demo
Home   >   mailing lists

pg_get_constraintdef throws SQL Error [XX000]: ERROR: invalid constraint type "n" (PG17) - Mailing list pgsql-bugs

From Pierre-Paul Hackens
Subject pg_get_constraintdef throws SQL Error [XX000]: ERROR: invalid constraint type "n" (PG17)
Date
Msg-id CAJd6cTJRYd7uimJkkSSNd-XZx3YH5kRShYRiRaxcgT9i=cxFcg@mail.gmail.com
Whole thread Raw
Responses Re: pg_get_constraintdef throws SQL Error [XX000]: ERROR: invalid constraint type "n" (PG17)
List pgsql-bugs
Tree view
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



pgsql-bugs by date:

Previous
From: Mor Lehr
Date:
Subject: Re: Missing semicolumn in anonymous plpgsql block does not raise syntax error
Next
From: PG Bug reporting form
Date:
Subject: BUG #18797: pointer te->defn not checked for NULL