Thread: Re: CREATION OF PRIMARY KEYS
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 ]
Very helpful that. What I meant by 'Can't find anything in the documentation' is I can't find anything in the documentation (i.e SYNTAX wise) on how you do this at table creation. Thanks in advance to anyone with any help on this. Andy. "Szabo Zoltan" <col@econet.hu> wrote in message news:3BB337E9.7B304318@econet.hu... > 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 ] > >
Thankyou, I have now resolved this issue. "Andy Hallam" <ahm@exel.co.uk> wrote in message news:9ovhej$1kt$1@news.tht.net... > Very helpful that. > > What I meant by 'Can't find anything in the documentation' is I can't find > anything in the documentation (i.e SYNTAX wise) on how you do this at table > creation. > > Thanks in advance to anyone with any help on this. > > Andy. > > > "Szabo Zoltan" <col@econet.hu> wrote in message > news:3BB337E9.7B304318@econet.hu... > > 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 ] > > > > > >