ERROR: Unique constraint already exists for columns ... in table ...

Reason:

You attempted to create a unique constraint using create_unique_constraint() on a table that already has a unique constraint defined on the same columns.

Resolution:

Ensure you specify a combination of columns without a unique constraint defined on them.

Tips:

  • Use the star$constraints view to find the columns within pre-existing unique constraints.
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk