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

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: Srinath Reddy Sadipiralla <srinath2133(at)gmail(dot)com>
Cc: msdnchina(at)163(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem.
Date: 2025-12-11 07:29:45
Message-ID: 202512110728.qdjdihtm7pmg@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

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