Re: SET NULL / SET NOT NULL - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: SET NULL / SET NOT NULL
Date
Msg-id Pine.LNX.4.30.0203220129420.812-100000@peter.localdomain
Whole thread Raw
In response to Re: SET NULL / SET NOT NULL  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: SET NULL / SET NOT NULL  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Re: SET NULL / SET NOT NULL  ("D'Arcy J.M. Cain" <darcy@druid.net>)
List pgsql-hackers
Christopher Kings-Lynne writes:

> Do we want the above syntax, or this syntax:
>
> ALTER TABLE blah ALTER COLUMN col SET NOT NULL;
> ALTER TABLE blah ALTER COLUMN col SET NULL;

My only objection to the second command is that it's plain wrong.  You
don't set anything to NULL, so don't make the command look like it.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Problem with reloading groups in pg_hba.conf
Next
From: Bruce Momjian
Date:
Subject: Re: SET NULL / SET NOT NULL