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

Reason:

You attempted to insert rows in a table using insert_rows() but the rows being inserted violate a foreign key constraint on the table. That is, one or more rows being inserted contain 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:

Do not insert rows that violate a foreign key constraint.

Tips:

  • The error message identifies the columns in the foreign key constraint.
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk