Hi! ----- Original Message ----- From: "Victor Pendleton" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, March 18, 2004 8:21 PM Subject: Re: InnoDB - alter column
> 1. The column types must match in order to establish a foreign key > relationship. Alter the data type would invalidate the Foreign key. Therefore > the key must be dropped first. > > 2. You can not have a relationship on a column that does not exists. Once again > the key must first be dropped. > > 3-4. Currently the user is unable to name Foreign key constraints. Consequently > the only way to know the constraint names is to use `show create table`. in 4.0.18, and upcoming 4.1.2 you can explicitly name a foreign key constraint. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html > On Thu, 18 Mar 2004, Gilad Buzi wrote: > > > > Hello, > > Does anyone have any idea why the following don't work in MySQL > > 4.1.1-alpha with InnoDB tables: > > 1. cannot change column type without first dropping the foreign key > > (when there is one) > > 2. cannot drop the column without first dropping the foreign key (if > > there is one) > > 3. cannot explicitly define a constraint's name when creating it. > > 4. cannot automatically figure out the names of the constraints > > associated with a column without manually parsing the results of "show > > create table" > > > > I sent a more detailed explanation a couple of days ago. I'm just > > wondering if this is by design or something planned to be fixed. > > > > thanks, > > > > *Gilad Ezra Buzi > > *R&D Engineer > > Open Source Advocate > > > > *Concatel* > > Avenida Puertos de Europa 100, > > 08040 Barcelona (Spain) > > tel. +34.93.567.97.10 > > fax +34.93.567.97.11 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]