Re: Multiple Primary Keys

Thanks all by response.

Isaias
----- Original Message -----
From: "Manfred Koizar" <mkoi-pg@aon.at>
To: "Isaías Cristiano Barroso" <isaias@unimedjm.com.br>
Cc: <pgsql-general@postgresql.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@unimedjm.com.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
>