Function pg_get_constraintdef

From: Erki Eessaar <erki(dot)eessaar(at)taltech(dot)ee>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Function pg_get_constraintdef
Date: 2024-11-21 11:46:45
Message-ID: AS8PR01MB75110350415AAB8BBABBA1ECFE222@AS8PR01MB7511.eurprd01.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Erki Eessaar 2024-11-21 12:04:04 Re: Function pg_get_constraintdef
Previous Message Alexander Kukushkin 2024-11-21 10:42:13 Re: pg_rewind WAL segments deletion pitfall