In this blog post, let’s learn about the error message “1045 The unique constraint cannot be used because it is deferrable.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1045 The unique constraint cannot be used because it is deferrable.
Reason for the Error
The referential constraint is referencing the unique constraint that is declared as deferrable. This is an internal error.
Solution
Check that the referential constraint references a unique constraint that is not declared deferrable. Contact your service provider