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. > > > > Postgres was trying to create another primary key instead of modify the > > existing primary key. > > > > So... > > > > As I understand it, a table does not always have to have a primary key > > defined. > > > > Would it work to first delete/drop the primary key, then recreate the > > primary key on all 6 columns. > > > > ALTER TABLE product_price DROP CONSTRAINT product_price_pkey; > > > > I tried this, but it doesn't seem to work... If I look at the table > > from pgAdmin, it is still there, reindexable, I can't add a new primary > > key, etc. But if I try to run the above command twice, it says it's > > already been removed. > > What version are you using? The above sort of thing seems to work for me > on my 8.2 devel machine (in a small test, including recreating the key) > and I had thought it should on 8.1 as well. > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster -- Daniel *-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*- Have a GREAT Day! Daniel Kunkel DanielKunkel@xxxxxxxxxxxx BioWaves, LLC http://www.BioWaves.com 14150 NE 20th St. Suite F1 Bellevue, WA 98007 800-734-3588 425-895-0050 http://www.WizCity.com http://www.Illusion-Optical.com *-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-
