Manual says:
"(But a primary key cannot be added after table creation.)"
http://www.postgresql.org/idocs/index.php?indices-unique.html
If you do not read manual, or do not search, probably you can't read what is
written there ;)
CoL
Andy Hallam wrote:
> 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
--
[ Szabo Zoltan ]
[ software fejleszto ]
[ econet.hu Informatikai Rt. ]
[ 1117 Budapest, Hauszmann A. u. 3. ]
[ tel.: 371 2100 fax: 371 2101 ]