ERROR: One or more rows violate unique key constraint on ...

Reason:

You attempted to update rows in a table using update_rows() but the update violates a unique constraint on the table. That is, the update would cause one or more rows in the table to contain duplicate values in the columns of a unique constraint.

Resolution:

Do not update rows which will violate a unique constraint.

Tips:

• The error message identifies the columns in the unique constraint.