Request a Demo
Home   >   mailing lists

Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. - Mailing list pgsql-bugs

From Álvaro Herrera
Subject Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem.
Date
Msg-id 202512110728.qdjdihtm7pmg@alvherre.pgsql
Whole thread Raw
In response to Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem.  (Srinath Reddy Sadipiralla <srinath2133@gmail.com>)
Responses Re:Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem.
List pgsql-bugs
Tree view 
On 2025-Dec-10, Srinath Reddy Sadipiralla wrote:

> ah... just after a quick code lookup, remembered that
> "not null" is treated as a column property, which is a
> flag in pg_attribute catalog table named as "attnotnull",

This is no longer true in 18.
https://www.enterprisedb.com/blog/changes-not-null-postgres-18

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
"Fundamental layering violations tend to bite you on tender
parts of your anatomy."                          (Tom Lane)
https://postgr.es/m/2818249.1748706121@sss.pgh.pa.us

pgsql-bugs by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem.
Next
From: Etsuro Fujita
Date:
Subject: Re: BUG #19339: odbc_fdw extension, Not able to read data from foreign tables