On Thu, Jun 19, 2008 at 12:13 AM, qkiss <[EMAIL PROTECTED]> wrote: > Thanks for the reply. I probably was not clear enough. I am referring > specifically to Postgresql column constraints (http:// > www.postgresql.org/docs/8.3/interactive/sql-createtable.html). These > attributes allow you to create a relation where constraints are > present on both tables and they enforce the presence of the primary > keys before you insert the many-to-many row in the table that makes > that relation (I hope you understand what I just wrote ;) ). Having > these attributes set allow you to do a lazy checking of constraints at > the commit time, not at the insert time.
Yes, it's clear now. Well, no, you can't change this on ManyToMany. In fact, you can't change much on those. I have to think of a way to enable people to get their table the way they like without me adding 4000 different options. What I think we need is some kind of template, but I'm not sure yet how to represent them. > When I did not have them set, > I got an error while making inserts. It seemed like Elixir do not pay > attention on the order of insertions (it wants to insert values into > the relation-binding table before it inserted the reffered values > itself). Strange. That shouldn't be the case. If it is, it's either you are doing something weird or it's a bug (possibly in SQLAlchemy). Could you send a self-contained (and as small as possible) test case? > However I began to wonder what do you mean with this > "lazy=False" attribute, as I did not come across it earlier. I will > have to check it, maybe it is the parameter I need. No, that's something totally unrelated (though it's still interesting to know about it). > I can send you the modified file, but should I paste the whole file > here, or just the diffs or maybe email you? A diff is best, and I prefer them as attachments rather than copy-pasted. -- Gaëtan de Menten http://openhex.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLElixir" 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/sqlelixir?hl=en -~----------~----~----~----~------~----~------~--~---
