Thanks Heikki for your response : it works perfectly with the brand new version (4.1.6),
I'm gonna drop all my old foreign keys now and rename them with an appropriate name... bye -- Richard FURIC CEDRICOM Tel : 02 99 55 07 55 Fax : 02 99 55 08 64 E-mail : [EMAIL PROTECTED] site vitrine : www.cedricom.com ""Heikki Tuuri"" <[EMAIL PROTECTED]> a écrit dans le message news: [EMAIL PROTECTED] > Martijn, > > ----- Original Message ----- > From: ""Martijn Tonies"" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Wednesday, October 20, 2004 10:08 AM > Subject: Re: Innodb foreign keys names > > > Hello Heikki, > >> > > >> >> you have to use a fairly recent 4.0 or 4.1 version of MySQL. > >> > > >> >Does a newer version allow you to change/set the names yourself? > >> > >> you can give the name yourself in new versions. Please look at the InnoDB > >> manual section. > > > > "A constraint name can be given as of MySQL 4.0.18" > > > > Ah, by itself - a great feature. Pain in the *** though, that it has been > > added in (yet another) _minor_ MySQL update. This makes providing > > tools for it quite a burden... > > the change was necessary to get DROP FOREIGN KEY to replicate. It was a bug > fix, that is why I put the change to a minor MySQL version: > > " > Fixed a bug: generate FOREIGN KEY constraint identifiers locally for each > table, in the form db_name/tbl_name_ibfk_number. If the user gives the > constraint name explicitly, then remember it. These changes should ensure > that foreign key id's in a slave are the same as in the master, and DROP > FOREIGN KEY does not break replication. (Bug #2167) > " > > I agree that in the future, we have to try to make less changes to stable > versions of MySQL, and put new features only in new major versions. > > > The good thing: this is an addition, unlike renaming a column returned > > from SHOW TABLES :-/ > > > > > > Thanks for pointing this out. > > > > With regards, > > > > Martijn Tonies > > 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 > > Order MySQL technical support from https://order.mysql.com/ > > > > Database Workbench - developer tool for InterBase, Firebird, MySQL & MS > > SQL > > Server. > > Upscene Productions > > http://www.upscene.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
