Horton

Re: Modifying NOT NULL Constraint

Chris <chrisb@nimrod.itg.telstra.com.au>

View thread
From: Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Dan Wilson <dan_wilson@geocities.com>, pgsql-hackers@postgresql.org
Date: 2000-06-14T06:35:45Z
Lists: pgsql-hackers 
Tom Lane wrote:

> What do you think should happen if there are null values?  Refuse the
> command?  Delete the non-compliant rows?  Allow the rows to remain
> even though the column is now nominally NOT NULL?

I would vote for refuse the command. It enforces the integrity of the
data.
You can always do an appropriate update command first if you think there
are 
nulls in there.