Re: Multiple Primary Keys

Thanks all by response.

Isaias
----- Original Message -----
From: "Manfred Koizar" <mkoi-pg(at)aon(dot)at>
To: "Isaías Cristiano Barroso" <isaias(at)unimedjm(dot)com(dot)br>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, January 15, 2003 1:00 PM
Subject: Re: [GENERAL] Multiple Primary Keys

> On Wed, 15 Jan 2003 11:14:04 -0200, Isaías Cristiano Barroso
<isaias(at)unimedjm(dot)com(dot)br>
> wrote:
> >CREATE TABLE A ( FIELD1 INT PRIMARY KEY, FIELD2 INT PRIMARY KEY);
> >ERROR: CREATE TABLE / PRIMARY KEY multiple primary keys for table 'A' are
not allowed.
>
> The error message says it all.
>
> >CREATE TABLE A ( FIELD1 INT , FIELD2 INT , PRIMARY KEY(FIELD1, FIELD2);
> ^
> This should work, if you add a ) here --------------------------------+
>
> Servus
> Manfred
>