ERROR: No primary key constraint exists on table ...

Reason:

You attempted to create a foreign key constraint using create_foreign_constraint() and the table referenced for the primary key does not have a primary key constraint defined.

Resolution:

Ensure the foreign key constraint references a table with a primary key constraint on it.

Tips:

  • Use the star$constraints view to find the tables with primary key constraints.
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk