6 messages in com.mysql.lists.clusterRE: How to convert tables with primar...
FromSent OnAttachments
John Wood14 May 2007 12:49 
John David Duncan14 May 2007 12:57 
John Wood14 May 2007 13:04 
Geert Vanderkelen14 May 2007 22:03 
John Wood15 May 2007 10:52 
Martin Skold16 May 2007 00:18 
Subject:RE: How to convert tables with primary keys using InnoDB to ndbcluster
From:John Wood (jwo@skywaysystems.com)
Date:05/14/2007 01:04:54 PM
List:com.mysql.lists.cluster

Hi, JD.

Thank you for the reply. I tried this for giggles before and keep running into this same error in the process:

"Error while executing query.

ALTER TABLE `SkyWayTTS`, `vehicle` DROP PRIMARY KEY, ENGINE=ndbcluster;

ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails

John J. Wood Unix Systems Administrator Skyway Systems, Inc. Broomfield, CO 80038 Phone: 303-217-8575 (ext: 206) Email: jwo@skywaysystems.com

"You think I'm over the hill, think I'm past my prime, Let me see what you've got, we can have a whoppin' good time." - Bob Dylan