PSQLODBC and TRANSACTIONS

From: "Jose' Soares" <jose(at)sferacarta(dot)com>
To: "pgsql-interfaces(at)postgreSQL(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Subject: PSQLODBC and TRANSACTIONS
Date: 1999-01-12 09:55:31
Message-ID: 369B1C13.9E56EE17@sferacarta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
psqlodbc_4294795803.log application/x-unknown-content-type-log_auto_file 4.9 KB

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Byron Nikolaidis 1999-01-12 15:55:23 Re: [INTERFACES] PSQLODBC and TRANSACTIONS
Previous Message Hu Yu 1999-01-12 02:12:18 How to connect with Oracle for NT?