Set NOT NULL error

From: Michael Rowan <mike(dot)rowan(at)internode(dot)on(dot)net>
To: postgresql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Set NOT NULL error
Date: 2011-11-21 03:32:33
Message-ID: 60C5D86D-9476-473D-A4B2-9A33958385D8@internode.on.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2011-11-21 07:59:49 Re: Set NOT NULL error
Previous Message Arvind Sharma 2011-11-19 02:20:09 Re: Access to pg_hba.conf