Tom Lane wrote:
> 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?)
Yes, I like this too; the SET/DROP symetry.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026