Re: PLS HELP: ERROR 1452 (23000) Foreign Key Constraint
Just upgraded to 5.5.11 and same error:
ERROR 1452 (23000) at line 55: Cannot add or update a child row: a foreign key constraint fails (`constraint_test`.`beneficiary`, CONSTRAINT `FK41BADEC55CE3480` FOREIGN KEY (`insured_id`) REFERENCES `Insured` (`insured_id`))
Peter, may I ask, did you run execute it from the command line? Like so:
mysql constraint_test < ./constraint-test.sql
BTW, I am running on Mac OS X 10.6 not that I think it should matter...
Any suggestions would be appreciated, please.
Subject
Written By
Posted
Re: PLS HELP: ERROR 1452 (23000) Foreign Key Constraint
April 05, 2011 11:13PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.