CREATION OF PRIMARY KEYS - Mailing list pgsql-general

Hi all.

I'm trying to create a PRIMARY KEY on a table I've created but am not having
any success.

TABLE SCHEMA SQL = :

CREATE TABLE X (XCOL CHAR(10))


When I execute either of the below 2 ALTER TABLE commands:

ALTER TABLE X ADD CONSTRAINT PK_X PRIMARY KEY (XCOL)
or
ALTER TABLE X ADD PRIMARY KEY (XCOL)


I keep getting the following error message:

ERROR: ALTER TABLE/ ADD CONSTRAINT is not implemented for that constraint
type. (State:S1000, Native Code: 7)


Can't find anything in the documentation?

Any ideas ?

thanks.

Andy
ahm@exel.co.uk