Jeff Davis <pgsql@xxxxxxxxxxx> writes: > I think all you need to do what you want is something like: > ALTER TABLE foo DROP CONSTRAINT foo_pkey KEEP INDEX; > Because then you could drop the primary key status on a column without > affecting the column or the index, then use my suggested syntax to > switch the primary key status to a different index like so: > ALTER TABLE foo SET PRIMARY KEY INDEX foo_othercolumn_index; That seems like an awful lot of uglification simply to let the index be marked as "primary key" rather than just "unique". regards, tom lane
