Adolfo, the following patch in the 4.0 tree may fix the misleading error message:
------------------------------------------------ D 1.222 04/10/12 18:11:50+03:00 [EMAIL PROTECTED] 357 356 1/1/5101 P sql/ha_innodb.cc C Change error code to HA_ERR_ROW_IS_REFERENCED if we cannot DROP a parent table referenced by a FOREIGN KEY constraint; this error number is less misleading th an the previous value HA_ERR_CANNOT_ADD_FOREIGN, but misleading still; we should introduce to 5.0 a proper MySQL error code The patch will be merged into 4.1.7. Best regards, Heikki Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL support from http://www.mysql.com/support/index.html ............... From: Adolfo Bello ([EMAIL PROTECTED]) Subject: Weirdness (or bug) with DROP TABLE This is the only article in this thread View: Original Format Newsgroups: mailing.database.myodbc Date: 2004-10-06 13:03:59 PST I am using Mandrake 10, MySQL 4.1.5 from RPM downloaded from dev.mysql.com. Look at this session: ==== $ mysql -u root -p permarn Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 4.1.5-gamma-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select * from tblinstructivos; Empty set (0.00 sec) mysql> drop table tblinstructivos; ERROR 1051 (42S02): Unknown table 'tblinstructivos' mysql> select * from `tblinstructivos`; Empty set (0.00 sec) mysql> drop table `tblinstructivos`; ERROR 1051 (42S02): Unknown table 'tblinstructivos' mysql> ===== Why I can not drop this particular table? No problem with any other table. Every table in this database is InnoDB. I started mysql with the "--user=root" flag. Adolfo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]