While I do not know why, I would suggest you simply drop the PK and recreate
it, this should be a whole lot faster than the alter.
This took the same amount of time as the alter table (a little longer actually). The documentation says that in later versions of MySQL the drop index is mapped to alter table, so I'd pretty much expect it to work that way.
Kevin
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]