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.
