Introducing another primary key field?

From: Bjørn T Johansen <btj(at)havleik(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Introducing another primary key field?
Date: 2004-08-26 05:05:41
Message-ID: 412D6FA5.6040604@havleik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need to introduce an extra field in a table that has one field as
primary key. The "problem" is that this new field should be combined
with the existing pk to create a new combined pk for the table, how to I
change the table? Using the Alternate command? How? Or do I need to
create a new table and copy everything to the new table?

Cheers,

BTJ

--
-------------------------------------------------------------------------------
Bjørn T Johansen

bjorn(at)havleik(dot)com
-------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange
Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Deepa K 2004-08-26 05:44:34 Re: IP clash in the PC
Previous Message Jon Asher 2004-08-26 04:25:51 Querying large record sets