Start of change

-541 DUPLICATE TEMPORAL FOREIGN KEY CONSTRAINT EXISTS FOR TABLE table-name (constraint name).

Explanation

An attempt was made to add a FOREIGN KEY constraint. The table already has a constraint that is a duplicate of the constraint being added. A temporal FOREIGN KEY constraint is a duplicate if the columns in the constraint are the same as in another temporal foreign key constraint. An attempt was made to use the table in a FOREIGN KEY clause or in an SQL manipulative statement.

System action

The statement cannot be processed.

Programmer response

The constraint is already in effect.

SQLSTATE

42891

End of change