Re: SET NULL / SET NOT NULL

Peter Eisentraut <peter_e(at)gmx(dot)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