PSQLODBC and TRANSACTIONS - Mailing list pgsql-interfaces

From Jose' Soares
Subject PSQLODBC and TRANSACTIONS
Date
Msg-id 369B1C13.9E56EE17@sferacarta.com
Whole thread Raw
List pgsql-interfaces
Hi,

I'm trying transactions using M$-access and PSQLODBC without success,
Seems that backend locks itself
by opening two connections to work on the same table.

I have a table with 3 rows:

codice    nome        cap
---------------------------
1    pippo        0
2    pluto        0
3    topolino    0
---------------------------

I tryed to update table as:

UPDATE operatori SET cap = 1;

This works, but the next...

UPDATE operatori SET cap = 2;

At this point the backend was locked and I had to break connection...

(See attached log file)

Thanks for any help.

-Jose'-

Attachment

pgsql-interfaces by date:

Previous
From: "David Weiss"
Date:
Subject: PostgreSQL and VB5
Next
From: "Hu Yu"
Date:
Subject: How to connect with Oracle for NT?