On Thu, Jan 05, 2006 at 08:08:39PM -0800, Daniel Kunkel wrote: > Hi > > I'm trying to add another primary key to a table populated with data and > a number of foreign key constraints. > > The new column is populated with non-null data (a requirement as I > understand it to become a valid primary key) > > I tried: > > ALTER TABLE product_price > ADD CONSTRAINT product_price_pkey6 PRIMARY KEY > (product_id,product_price_type_id,currency_uom_id,product_store_group_id,from_date,product_price_purpose_id); > > without having any luck.
What's the exact error you got? -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
