[GNUe-dev] A note on concurrent updates using postgres

[Johannes Vetter]

Hi,

As I've found out yesterday there's a big difference in using either
'psycopg' or 'pygresql' driver for postgres-backends.

Having two concurrent sessions (using transaction isolation level
'serializable') both updating the same record but changing different
fields.

This does *not* work with psycopg, but works very well with 'pygresql'.
I haven't tested other backends or drivers yet. Maybe someone else can
do this and let us know about ...


Thanks,
Johannes
-- 
BYTEWISE Software GmbH          Tel +43 (5577) 89877-0
i.A. Johannes Vetter            Fax +43 (5577) 89877-66
A-6890 Lustenau, Enga 2         http://www.bytewise.at
-------------------------------------------------------
Wir bieten die Installation von Debian GNU/Linux auf
Servern für kleinere Netzwerke zum Pauschalpreis an.
Mehr dazu unter http://www.bytewise.at/texte/pl-debian

signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil