PGSQL - ALTER TABLE .. ALTER TABLE

[Raf]

Hi,

I'm using Postgres 7.2.3 and whilst \h ALTER TABLE shows me:

ALTER TABLE [ ONLY ] table [ * ]
    ALTER [ COLUMN ] column { SET DEFAULT value | DROP DEFAULT }

I can't seem to do:

borg=# ALTER TABLE my_table ALTER COLUMN my_column DROP NOT NULL;
ERROR:  parser: parse error at or near "NOT"
borg=#


Any ideas?  Is it just restricted to dropping defaults?

Cheers,

Rafiq