Postgres Pro
Downloads
Home   >   mailing lists

Re: information_schema and not-null constraints - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: information_schema and not-null constraints
Date
Msg-id 202309180743.ylf2sxsus3x3@alvherre.pgsql
Whole thread Raw
In response to Re: information_schema and not-null constraints  (Peter Eisentraut <peter@eisentraut.org>)
List pgsql-hackers
Tree view 
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/

pgsql-hackers by date:

Previous
From: "Zhijie Hou (Fujitsu)"
Date:
Subject: RE: [PoC] pg_upgrade: allow to upgrade publisher node
Next
From: Amul Sul
Date:
Subject: Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression