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

Reason:

You attempted to update rows in a table using update_rows() but the updates violate a foreign key constraint on the table. That is, the update contains values in the columns of a foreign key constraint that do not match primary key values in table referenced by the foreign key constraint.

Resolution:

You cannot update rows to violate a foreign key constraint.

Tips:

• The error message identifies the columns in the foreign key constraint.