Introducing another primary key field? - Mailing list pgsql-general

From Bjørn T Johansen
Subject Introducing another primary key field?
Date
Msg-id 412D6FA5.6040604@havleik.com
Whole thread Raw
Responses Re: Introducing another primary key field?  (Michael Glaesemann <grzm@myrealbox.com>)
List 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@havleik.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"

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: PSql won't Let me Set Varchar Column to 'true'
Next
From: Martha Chronopoulou
Date:
Subject: SPI query...