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. :) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---