In order to allow this operation to succeed, you must first either delete (i.e. drop) the other (and newly specified) primary key index, or alter the type of the other primary key index from being a primary key to either a regular index or unique index.