Hello.
perror 152 MySQL error code 152: Cannot delete a parent row Something prevents your query from deleting a parent row. In my opinion, it could be some lock from another transaction or query. root <[EMAIL PROTECTED]> wrote: > > Hi List , > > what does error no 152 mean , could not find anything useful from the > manual , was trying to drop a foreign key from an innodb table which has > its corresponding P Key in another table. > > Table T_Dropdown (Foreign Key ) references Table T_Questionnaire > ( T_QID ) > >> mysql >alter table T_Dropdown drop foreign key I_QId; >> ERROR 1025 (HY000): Error on rename of './lms/T_Dropdown' to >> './lms/#sql2-8f7-c2' (errno: 152) > > > **************** CAUTION - Disclaimer ***************** > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely > for the use of the addressee(s). If you are not the intended recipient, > please notify the sender by e-mail and delete the original message. Further, > you are not to copy, disclose, or distribute this e-mail or its contents to > any other person and any such actions are unlawful. This e-mail may contain > viruses. Infosys has taken every reasonable precaution to minimize this risk, > but is not liable for any damage you may sustain as a result of any virus in > this e-mail. You should carry out your own virus checks before opening the > e-mail or attachment. Infosys reserves the right to monitor and review the > content of all messages sent to or from this e-mail address. Messages sent to > or from this e-mail address may be stored on the Infosys e-mail system. > ***INFOSYS******** End of Disclaimer ********INFOSYS*** > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
