Re: CREATION OF PRIMARY KEYS

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    ]
>
>