On 13 April 2012 21:46, Richard Vézina ml.richard.vez...@gmail.com wrote:
This solution look great, because until now web2py was triggering a error
if postgres return not unique and won't insert the data...
This problem has bitten me again. My previous test was in the console.
Now in a
On 24 April 2012 15:41, Johann Spies johann.sp...@gmail.com wrote:
On 13 April 2012 21:46, Richard Vézina ml.richard.vez...@gmail.comwrote:
This solution look great, because until now web2py was triggering a error
if postgres return not unique and won't insert the data...
This problem has
This has nothing to do with it.
Anyway, recent version of web2py have automatic reconnect, if that is what
you are asking.
On Friday, 13 April 2012 02:20:53 UTC-5, Johann Spies wrote:
In the past, the database adapter disconnected when a constraint on the
database side prohibited a
On Friday, 13 April 2012 15:26:48 UTC+2, Massimo Di Pierro wrote:
This has nothing to do with it.
Anyway, recent version of web2py have automatic reconnect, if that is what
you are asking.
Here is an example of what I wanted to do and which did not work in the
past but I see it is now
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 don't remember how, but I think there is a way to tell web2py about
multiple column constraint. I customize validator for doing this...
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
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
On 13 April 2012 19:26, Michele Comitini michele.comit...@gmail.com wrote:
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
This solution look great, because until now web2py was triggering a error
if postgres return not unique and won't insert the data...
So, maybe as you suggest Johann this is not the case anymore with recent
web2py update, I don't know.
But I think we would need a confirmation about Massimo or
9 matches
Mail list logo