In this blog post, let’s learn about the error message “1090 Self-referencing constraints are currently not supported.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1090 Self-referencing constraints are currently not supported.
Reason for the Error
You attempted to create a self-referencing constraint. A referential constraint is self-referencing if the foreign key is referencing the primary key of the same table.
Solution
Remove the self-reference and resubmit
