Re: cataloguing NOT NULL constraints - Mailing list pgsql-hackers

On 7/24/23 18:42, Alvaro Herrera wrote:
> 55490 17devel 3166154=# create table foo (a int constraint nn not null);
> CREATE TABLE
> 55490 17devel 3166154=# alter table foo add constraint nn not null a;
> ERROR:  column "a" of table "foo" is already NOT NULL

Surely this should be a WARNING or INFO?  I see no reason to ERROR here.
-- 
Vik Fearing