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.