Function pg_get_constraintdef - Mailing list pgsql-bugs

From Erki Eessaar
Subject Function pg_get_constraintdef
Date
Msg-id AS8PR01MB75110350415AAB8BBABBA1ECFE222@AS8PR01MB7511.eurprd01.prod.exchangelabs.com
Whole thread Raw
Responses Re: Function pg_get_constraintdef
Re: Function pg_get_constraintdef
List pgsql-bugs
Hello

SELECT pg_get_constraintdef(c.oid)
FROM pg_catalog.pg_constraint c;

If I execute the query in two different servers with PostgreSQL 17.1 and in different databases in these servers, then I get the answer

ERROR:  invalid constraint type "n"

In case of an empty database I do not get the error. The query worked in the servers before upgrading to PostgreSQL 17.

If I execute the query in a database of a server with PostgreSQL 15, then I do not get the error. 

Best regards
Erki Eessaar



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18719: Bug Report for Patch (For inplace update durability, make heap_update() callers wait)
Next
From: Erki Eessaar
Date:
Subject: Re: Function pg_get_constraintdef