Am 13.02.2012 15:35, schrieb Paul J Stevens: > On 02/13/2012 03:24 PM, Reindl Harald wrote: >> hi >> >> is there a really good reason dropping all foreign keys >> and create them new? this queries are running a very >> long time (i am testing your convert-sql this moment) > > > This script was changed to be more robust in the face of slightly > different BIGINT columns. > > Changing the widths on columns involved in key constraints is only > possible after first dropping the key entirely. > > If the 'old' script (pre-today) worked for you: use that.
i will play around, something does not work here with the new one transition is running, time measure later [root@dbmail-test:/data/dbmail3-migration]$ ./convert.sh ERROR 1091 (42000) at line 200: Can't DROP 'owner_idnr_2'; check that column/key exists
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
