Index must have at least one column.

Your modification would result in an index without columns, which is illegal.  You can delete the index or modify it by adding a column to it.