Обсуждение: Multiple Primary Keys
Hi all,
How to create a table with multiple primary key?
I'm trying this manner but don't work.
CREATE TABLE A ( FIELD1 INT PRIMARY KEY, FIELD2 INT PRIMARY KEY);
and
CREATE TABLE A ( FIELD1 INT , FIELD2 INT , PRIMARY KEY(FIELD1, FIELD2);
But i've the following message:
ERROR: CREATE TABLE / PRIMARY KEY multiple primary keys for table 'A' are not allowed.
How to do?
Best Regards.
Isaías
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
=?iso-8859-1?Q?Isa=EDas_Cristiano_Barroso?= <isaias@unimedjm.com.br> writes:
> How to create a table with multiple primary key?
What? A table can only have one primary key, by definition.
What is it you're actually trying to accomplish?
regards, tom lane
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 >