Postgres Pro
Downloads
Home   >   mailing lists

Re: how to add primary key to existing table with multiple primary keys - Mailing list pgsql-sql

From Mauricio Fernandez A.
Subject Re: how to add primary key to existing table with multiple primary keys
Date
Msg-id CMEIKGCPKOPCGFKCNHLDAEKLCDAA.mfacontacto@ono.com
Whole thread Raw
In response to how to add primary key to existing table with multiple primary keys  ("Daniel Joo" <djoo@vistagen-inc.com>)
List pgsql-sql
Tree view
Your table has a primary key yet, so you can´t add a second primary key.  You only can define one pk, however it can be composed as your table has (it now has 2 columns), so I think you need to drop the current pk and add again the new pk with your 3 columns (probeid, tissueid, expid).
 
 

Mauricio Fernández A.
Ingeniero de Sistemas
Universidad Autónoma de Manizales (Colombia)

-----Mensaje original-----
De: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]En nombre de Daniel Joo
Enviado el: viernes, 24 febrero, 2006 2:45
Para: pgsql-sql@postgresql.org
Asunto: [SQL] how to add primary key to existing table with multiple primary keys

Hi there,

 

I am trying to add another primary key to an existing table with two other primary keys.  I got the following error when I tried this command:

 

alter table extprobe2tissue ADD primary key (expid);

ERROR:  multiple primary keys for table "extprobe2tissue" are not allowed

 

The details of the extprobe2tissue table is:

 

\d extprobe2tissue;

          Table "public.extprobe2tissue"

   Column    |          Type          | Modifiers

-------------+------------------------+-----------

 probeid     | integer                | not null

 tissueid    | integer                | not null

 value       | double precision       | not null

 entrydate   | date                   | not null

 description | character varying(200) |

 qval        | double precision       |

 expid       | integer                | not null

Indexes:

    "extprobe2tissue_pkey" PRIMARY KEY, btree (probeid, tissueid)

    "extprobe2tissue_probeid" btree (probeid)

    "extprobe2tissue_tissueid" btree (tissueid)

Foreign-key constraints:

    "extprobe2tissue_tissueid_fkey" FOREIGN KEY (tissueid) REFERENCES tissue(tissueid)

    "extprobe2tissue_probeid_fkey" FOREIGN KEY (probeid) REFERENCES extprobe(probeid)

 

Any suggestion would be much appreciated.

 

Thanks! 

pgsql-sql by date:

Previous
From: "AKHILESH GUPTA"
Date:
Subject: regarding grant option
Next
From: Florian Weimer
Date:
Subject: Re: Index to support LIKE '%suffix' queries