Re: SET NULL / SET NOT NULL

Peter Eisentraut <peter_e@gmx.net> writes:
> Using the standard precedent above, how about

> ALTER TABLE blah ALTER COLUMN col SET NOT NULL;
> ALTER TABLE blah ALTER COLUMN col DROP NOT NULL;

This seems like a good choice if we are not too concerned about
compatibility with other DBMSes.  (Which, for something like this,
I'm not; how many applications will be issuing programmed commands
like this?)
        regards, tom lane