Thread

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

yanliang lei <msdnchina@163.com> — 2025-12-12T10:23:24Z

Thanks for replying .


in the postgresql 18 ，not null has “Constraint Name”，and this is a PostgreSQL 18  New Feature.


so , i think that: this problem(BUG #19351) is a bug.



At 2025-12-11 15:29:45, "Álvaro Herrera" <alvherre@kurilemu.de> wrote:
>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