Hi Russell, On 27 Feb 2007, at 16:16, Russell Keith-Magee wrote: .. > Postgres has similar behaviour to InnoDB by default, but [4610] > modified the table declarations to disable constraint checking until > the end of a transaction using DEFFERABLE INITIALLY DEFERRED. However, > apparently MySQL doesn't implement this feature or an equivalent.
InnoDB doesn't have somethink like that no. > One way around the problem would be to use SET FOREIGN_KEY_CHECKS at > the start and end of each transactions - but if I'm reading the docs > right, this wouldn't validate any keys modified while the checks were > disabled. That's not good indeed. Not to be used to simulate deferred constraints. > Or, is there another approach that I am not aware of? No, not currently. Things are on their way, but that's all I can say for now :) Cheers, Geert -- Geert Vanderkelen http://some-abstract-type.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-developers?hl=en -~----------~----~----~----~------~----~------~--~---
