ERROR: Foreign key constraint already exists for columns ... in table ...

Reason:

You attempted to create a foreign key constraint using create_foreign_constraint() on a set of column that already have a foreign key constraint defined for them.

Resolution:

Ensure the foreign key constraint is on a set of columns without an existing foreign key constraint.

Tips:

  • Use the star$constraints view to find the foreign key constraints defined on the table
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk