Re: removing "not null" modifier

Achilleus Mantzios <achill@matrix.gatewaynet.com> writes:
> O Robert Urban ������ ���� Mar 13, 2006 :
>> how can I get rid of the "not null" modifier on status_id?  

> ALTER TABLE event ALTER status_id DROP NOT NULL;

I don't think 7.2 has that.  Of course, there are many excellent reasons
why Robert needs to get himself off 7.2.2 ASAP.  Some of them can be
found here:
http://developer.postgresql.org/docs/postgres/release.html
        regards, tom lane