From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Peter Eisentraut <peter@eisentraut.org>
Cc: Pg Hackers <pgsql-hackers@lists.postgresql.org>
Cc: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Subject: Re: information_schema and not-null constraints
Date: Mon, 18 Sep 2023 09:43:25 +0200
Message-ID: <202309180743.ylf2sxsus3x3@alvherre.pgsql> (raw)
In-Reply-To: <ea9fd77b-3feb-3f6b-1865-aa9d19b2c68a@eisentraut.org>
On 2023-Sep-18, Peter Eisentraut wrote:
> On 14.09.23 10:20, Peter Eisentraut wrote:
> > Small correction here: This should be
> >
> > pg_catalog.format('%s IS NOT NULL',
> > at.attname)::information_schema.character_data AS check_clause
> >
> > That is, the word "CHECK" and the parentheses should not be part of the
> > produced value.
>
> I have committed this fix.
Thanks.
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
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: pgsql-hackers@postgresql.org
Cc: alvherre@alvh.no-ip.org, peter@eisentraut.org, pgsql-hackers@lists.postgresql.org, peter.eisentraut@enterprisedb.com
Subject: Re: information_schema and not-null constraints
In-Reply-To: <202309180743.ylf2sxsus3x3@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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