Hi! I have a table with a compound key - the second is always known, and if the first one is not supplied explicitly, I would like to make it equal max(first_key) + 1.
I would like to do this with concurrency in mind, there could be two such requests at once, and I don't want them to get the same number - the 2 inserts may not conflict at all, as they could differ in the second part of the key. What could be the best solution for this? (If it's possible I'd like to avoid having a second table with a counter + lock). Thanks in advance, Adam -- You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en.
