Jonathan Ellis wrote: >On 2/16/07, jose <[EMAIL PROTECTED]> wrote: > > >>Gary Bernhardt wrote: >> >> >> >>>Referential integrity isn't being violated here - SA is nulling the >>>foreign key before deleting the row it points to. Try adding >>>nullable=False to the declaration of attivita.cod_specie. That should >>>make it fail in the way you expect, because SA will no longer be able >>>to null the foreign key. >>> >>> >>This seems to me a trick to avoid integrity referential. >>I expected the nullable=False was the default behavior for any foreign >>key otherwise the referential integrity is violated here? >>I'm very, very surprised for this behavior. >> >> > >Guess it would surprise you to learn about the SQL 92 "ON DELETE SET >NULL" functionality too. :) > > Seems to me the SQL92 'ON DELETE SET NULL' is an explicit functionality, instead in our case, SA does this functionality in implicit way. :-( I hope there's a sort of configuration to disable this functionality.
jo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
