Johan, To do what you want to achieve you could look into SAVEPOINTs. PostgreSQL supports them. They allow to recover the current transaction to a predefined savepoint in case of error. The DAL does not support SAVEPOINT support, yet, but you can use them through executesql().
mic Il 13 aprile 2012 19:15, Johann Spies <johann.sp...@gmail.com> ha scritto: > > > On 13 April 2012 16:52, Richard Vézina <ml.richard.vez...@gmail.com> wrote: >> >> In your model definition if you use : >> >> unique=True >> >> For each field, It should build your db correctly... But maybe you want >> both field together to be unique... > > > I know about 'unique'. The constraint I used in the example makes the > combination of fields unique. >> >> >> I don't remember how, but I think there is a way to tell web2py about >> multiple column constraint. I customize validator for doing this... I can >> show a bit the code if you want. > > > Previously I had to use web2py code to do a database lookup before an insert > to make sure that there is not already the same combination in the table. > Now, I am able to let the database do the work and I do not need an extra > lookup. Whatever web2py code there may be to solve a problem like this, it > will not be as efficient as that of the database. > > Regards > Johann > -- > Because experiencing your loyal love is better than life itself, > my lips will praise you. (Psalm 63:3) >