Re: Catalog domain not-null constraints - Mailing list pgsql-hackers

On 14.03.24 15:03, Alvaro Herrera wrote:
> On 2024-Mar-14, Peter Eisentraut wrote:
> 
>> Perhaps it would make sense if we change the ALTER TABLE command to be like
>>
>>      ALTER TABLE t1 ADD IF NOT EXISTS NOT NULL c1
>>
>> Then the behavior is like one would expect.
>>
>> For ALTER TABLE, we would reject this command if IF NOT EXISTS is not
>> specified.  (Since this is mainly for pg_dump, it doesn't really matter for
>> usability.)  For ALTER DOMAIN, we could accept both variants.
> 
> I don't understand why you want to change this behavior, though.

Because in the abstract, the behavior of

     ALTER TABLE t1 ADD <constraint specification>

should be to add a constraint.

In the current implementation, the behavior is different for different 
constraint types.