Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Neil Aggarwal (neilJAMMConsulting.com)
Date: Fri Apr 02 2010 - 13:52:25 CDT
> Just check it up that any active transaction is still there in innodb
> internal data dictionary.
Acutally I figured it out.
There was a constraint on that column as well.
Once I dropped the constraint, I was able to drop the index.
Thanks for the help,
Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net/mysql
MySQL pre-installed on a virtual private server for $25/mo
Unmetered bandwidth = no overage charges, 7 day free trial
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql