Il giorno mar, 26/04/2005 alle 22.57 +0000, dick-CPb864HZPxw@xxxxxxxxxxxxxxxx
ha scritto:
> Hi List,
>
> Sorry to keep on bothering you. Included is a short piece of code that I use
> to start a transaction.
[snip]
> Note the 'SET session characteristics as transaction isolation level read
> committed'. What I do NOT understand is that I can get the message "Cannot
> serialize access due to concurrent access"
All cursors derived from the same connection share the same transaction.
The problem can be that you're trying to set the isolation level after
the transaction has begun. It is much better to use psycopg
set_isolation_level connection method that will close any open
transaction and start a new one with the given isolation level.
federico
--
Federico Di Gregorio http://people.initd.org/fog
Debian GNU/Linux Developer
fog-8fiUuRrzOP0dnm+yROfE0A@xxxxxxxxxxxxxxxx
INIT.D Developer
fog-NGVKUo/i/6DYtjvyW6yDsg@xxxxxxxxxxxxxxxx
Those who do not study Lisp are doomed to reimplement it. Poorly.
-- from Karl M. Hegbloom .signature
signature.asc
Description: This is a digitally signed message part
_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/+sw@xxxxxxxxxxxxxxxx
http://lists.initd.org/mailman/listinfo/psycopg
| 
