Jeff Davis <pgsql@j-davis.com> 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