OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
RE: Can't drop index

From: Neil Aggarwal (neilJAMMConsulting.com)
Date: Fri Apr 02 2010 - 13:52:25 CDT

Krishna:

> 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

--
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