Re: DB API 2.0 and transactions

2005-06-16 Thread Stuart Bishop
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Magnus Lycka wrote: > Another option would be to investigate if any of the other postgreSQL > drivers have a more correct behaviour. The non-standard behaviour that > you describe it obvious from the pgdb source. See: > http://www.pygresql.org/cvsweb.

Re: DB API 2.0 and transactions

2005-06-13 Thread Magnus Lycka
I'm CC:ing this to D'Arcy J.M. Cain. (See comp.lang.python for prequel D'Arcy.) Christopher J. Bottaro wrote: > Check this out... > > > import pgdb > import time > > print time.ctime() > db = pgdb.connect(user='test', host='localhost', database='test') > time.sleep(5) > db.cursor().execute('ins

Re: DB API 2.0 and transactions

2005-06-10 Thread Christopher J. Bottaro
Magnus Lycka wrote: > You might have spotted a fairly nasty bug there! > PostgreSQL violates the SQL standards by running in autocommit mode > unless you explicitly perform its non-standard BEGIN command. If you > are right about the behaviour you describe, the PostgreSQL binding > for Python t

Re: DB API 2.0 and transactions

2005-06-10 Thread Magnus Lycka
You might have spotted a fairly nasty bug there! Christopher J. Bottaro wrote: > Hi, > Why is there no support for explicit transactions in the DB API? I mean > like transaction() to start the trans and commit() and rollback() would end > the trans or something. To quote from Date & Darwen "A Gu

Re: DB API 2.0 and transactions

2005-06-09 Thread flyingfred0
I've found it's occasionally necessary to go one lever deeper and use the _pg module directly so you are in control of your transactions (instead of letting pgdb automatically put you in one). vincent wehren wrote: > "Christopher J. Bottaro" <[EMAIL PROTECTED]> schrieb im > Newsbeitrag news:[EMA

Re: DB API 2.0 and transactions

2005-06-07 Thread vincent wehren
"Christopher J. Bottaro" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] | Hi, | Why is there no support for explicit transactions in the DB API? I mean | like transaction() to start the trans and commit() and rollback() would end | the trans or something. | | The reason why I as

DB API 2.0 and transactions

2005-06-07 Thread Christopher J. Bottaro
Hi, Why is there no support for explicit transactions in the DB API? I mean like transaction() to start the trans and commit() and rollback() would end the trans or something. The reason why I ask is because I wrote a daemon that interacts with a Postgres DB. The value of CURRENT_TIMESTAMP accor