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(dot)rowan(at)internode(dot)on(dot)net
11 Kingscote Street
ALBERTON
South Australia 5014
tel 618 8240 3993