Re: [web2py] Re: db._adapter.reconnect()

2012-04-24 Thread Johann Spies
On 24 April 2012 15:41, Johann Spies wrote: > On 13 April 2012 21:46, Richard Vézina 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

Re: [web2py] Re: db._adapter.reconnect()

2012-04-24 Thread Johann Spies
On 13 April 2012 21:46, Richard Vézina 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 controller I did the followin

Re: [web2py] Re: db._adapter.reconnect()

2012-04-13 Thread Richard Vézina
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 othe

Re: [web2py] Re: db._adapter.reconnect()

2012-04-13 Thread Johann Spies
On 13 April 2012 19:26, Michele Comitini 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 SAVEPOINT support, yet,

Re: [web2py] Re: db._adapter.reconnect()

2012-04-13 Thread Michele Comitini
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 april

Re: [web2py] Re: db._adapter.reconnect()

2012-04-13 Thread Johann Spies
On 13 April 2012 16:52, Richard Vézina 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 combina

Re: [web2py] Re: db._adapter.reconnect()

2012-04-13 Thread Richard Vézina
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...

[web2py] Re: db._adapter.reconnect()

2012-04-13 Thread Johann Spies
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

[web2py] Re: db._adapter.reconnect()

2012-04-13 Thread Massimo Di Pierro
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 transa