-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.
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
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
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
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
"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
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