Set NOT NULL error

This command run from the SQL window of pgAdmin3 results in an error:

In the table vehicle there is a column maker_id
There is no data in the table, it is newly created.

ALTER TABLE vehicle ADD CONSTRAINT maker_id SET NOT NULL;

ERROR: syntax error at or near "SET"

AKAICS thats a direct copy of the required command in the PostgreSQL 9.1 docs, so I wonder what provokes the error?


Michael Rowan
mike.rowan@internode.on.net

11 Kingscote Street
ALBERTON
South Australia 5014

tel 618 8240 3993