[GENERAL] Adding another primary key to a populated table

2006-01-05 Thread Daniel Kunkel
aniel *-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*- Have a GREAT Day! Daniel Kunkel [EMAIL PROTECTED] BioWaves, LLC http://www.BioWaves.com 14150 NE 20th St. Suite F1 Bellevue, WA 98007 800-734-3588425-895-0050 http://www.WizC

Re: [GENERAL] Adding another primary key to a populated table

2006-01-05 Thread Daniel Kunkel
o run the above command twice, it says it's already been removed. -- Just for the record... the error message I got was: ERROR: ALTER TABLE / PRIMARY KEY multiple primary keys for table 'product_price' are not allowed On Fri, 2006-01-06 at 05:19 +, Andrew - Supernews wrote:

Re: [GENERAL] Adding another primary key to a populated table

2006-01-05 Thread Daniel Kunkel
ou just want > UNIQUE, NOT NULL values in a field, you can achieve that without > creating a primary key. > > Aaron > > On 1/5/06, Daniel Kunkel <[EMAIL PROTECTED]> wrote: > Hi > > It makes sense that I can't have more than 1 pr

Re: [GENERAL] Adding another primary key to a populated table

2006-01-06 Thread Daniel Kunkel
the table and > building the replacement table with the correct properties > then repopulating the table with the dumped data? > > On Thu, 2006-05-01 at 23:02 -0800, Daniel Kunkel wrote: > > Why do I want to include 6 fields in the primary key? > > > > Good quest

Re: [GENERAL] Adding another primary key to a populated table

2006-01-06 Thread Daniel Kunkel
Hi Thank you for taking time to give that a try. I'm currently running 7.3.10. On Fri, 2006-01-06 at 07:50 -0800, Stephan Szabo wrote: > On Thu, 5 Jan 2006, Daniel Kunkel wrote: > > > It makes sense that I can't have more than 1 primary key. > > > > Pos