ive heard of foreign key constraints that dont take effect until the tranasction actually commits, but I have never actually seen this in practice. which databases support this feature ? i didnt think it was so common (though not surprised PG supports it).
On Feb 22, 2007, at 1:15 PM, Luke Stebbing wrote: > > Are there any plans to handle circular dependencies by using > deferrable foreign key constraints when available? > > In my case, I had made the foreign key constraints deferred, but > SQLAlchemy didn't pick up on that when I reflected the database > metadata. I eliminated the circular dependency by using > post_update=True, but that meant dropping a NOT NULL constraint since > postgres can't defer those (sigh). > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
