public inbox for [email protected]  

help / color / mirror / Atom feed

From: [email protected]
To: [email protected]
Subject: Re: Postgres 17 domains with NOT NULL and pg_get_constraintdef()
Date: Wed, 8 Jan 2025 19:39:25 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

Am 08.01.25 um 14:10 schrieb Alvaro Herrera:
>> However, because the domain is defined with NOT NULL, this fails with
>>
>>> ERROR: invalid constraint type "n"
>>
>> with 17.2 on Windows and Linux.
>>
>> This is a result of storing the NOT NULL constraint in pg_constraint
>> and can easily be avoided by either using contype <> 'n' or by not calling
>> pg_get_constraintdef if contype = 'n'
>
> Yeah, thanks for the report -- this is clearly a bug and it was fixed
> already in the 17 branch, but it's not been released yet.  It'll be in
> the February release.

Thanks for the confirmation.

reply

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Postgres 17 domains with NOT NULL and pg_get_constraintdef()
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox