Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.9.1/8.9.1) with ESMTP id EAA15934 for ; Tue, 12 Jan 1999 04:58:47 -0500 (EST) (envelope-from jose@sferacarta.com) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.8.6/8.8.6/NETTuno 3.1) with ESMTP id KAA17006 for ; Tue, 12 Jan 1999 10:58:23 +0100 (MET) Received: from rosso.sferacarta.com (sferacarta.com) [10.20.30.5] by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian)) id 1001V4-0006lf-00; Tue, 12 Jan 1999 10:56:42 +0000 Message-ID: <369B1C13.9E56EE17@sferacarta.com> Date: Tue, 12 Jan 1999 10:55:31 +0100 From: "Jose' Soares" Reply-To: sferac@bo.nettuno.it Organization: Sfera Carta Software X-Mailer: Mozilla 4.05 [en] (Win95; I) MIME-Version: 1.0 To: "pgsql-interfaces@postgreSQL.org" Subject: PSQLODBC and TRANSACTIONS Content-Type: multipart/mixed; boundary="------------091198F5249071AFA7AC7535" This is a multi-part message in MIME format. --------------091198F5249071AFA7AC7535 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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'- --------------091198F5249071AFA7AC7535 Content-Type: application/x-unknown-content-type-log_auto_file; name="psqlodbc_4294795803.log" Content-Transfer-Encoding: base64 Content-Disposition: inline; filename="psqlodbc_4294795803.log" Y29ubj01MjU1OTk5MiwgU1FMRHJpdmVyQ29ubmVjdCggaW4pPSdEU049UG9zdGdyZVNRTDtV SUQ9O0RBVEFCQVNFPWh5Z2VhO01hcmNvO1BXRD07JywgZkRyaXZlckNvbXBsZXRpb249MQ0K RFNOIGluZm86IERTTj0nUG9zdGdyZVNRTCcsc2VydmVyPSd2ZXJkZScscG9ydD0nNTQzMics ZGJhc2U9J2h5Z2VhJyx1c2VyPSdtYXJjbycscGFzc3dkPScnDQogICAgICAgICAgcmVhZG9u bHk9JzAnLHByb3RvY29sPSc2LjQnLHNob3dvaWQ9JzAnLGZha2VvaWRpbmRleD0nMCcsc2hv d3N5c3RhYmxlPScwJw0KICAgICAgICAgIGNvbm5fc2V0dGluZ3M9J3NldCBrc3FvIHRvICdv bic7Jw0KICAgICAgICAgIHRyYW5zbGF0aW9uX2RsbD0nJyx0cmFuc2xhdGlvbl9vcHRpb249 JycNCkdsb2JhbCBPcHRpb25zOiBWZXJzaW9uPScwNi40MC4wMDA0JywgZmV0Y2g9MTAwLCBz b2NrZXQ9NDA5NiwgdW5rbm93bl9zaXplcz0yLCBtYXhfdmFyY2hhcl9zaXplPTI1NCwgbWF4 X2xvbmd2YXJjaGFyX3NpemU9NDA5NA0KICAgICAgICAgICAgICAgIGRpc2FibGVfb3B0aW1p emVyPTAsIGtzcW89MSwgdW5pcXVlX2luZGV4PTEsIHVzZV9kZWNsYXJlZmV0Y2g9MA0KICAg ICAgICAgICAgICAgIHRleHRfYXNfbG9uZ3ZhcmNoYXI9MSwgdW5rbm93bnNfYXNfbG9uZ3Zh cmNoYXI9MSwgYm9vbHNfYXNfY2hhcj0wDQogICAgICAgICAgICAgICAgZXh0cmFfc3lzdGFi bGVfcHJlZml4ZXM9J2RkXzsnLCBjb25uX3NldHRpbmdzPScNDQoNDQonDQpjb25uPTUyNTU5 OTkyLCBxdWVyeT0nICcNCmNvbm49NTI1NTk5OTIsIHF1ZXJ5PSdzZXQgRGF0ZVN0eWxlIHRv ICdJU08nJw0KY29ubj01MjU1OTk5MiwgcXVlcnk9J3NldCBrc3FvIHRvICdPTicnDQpjb25u PTUyNTU5OTkyLCBxdWVyeT0nDQoNCicNCmNvbm49NTI1NTk5OTIsIHF1ZXJ5PSdzZXQga3Nx byB0byAnb24nJw0KY29ubj01MjU1OTk5MiwgcXVlcnk9J3NlbGVjdCBvaWQgZnJvbSBwZ190 eXBlIHdoZXJlIHR5cG5hbWU9J2xvJycNCiAgICBbIGZldGNoZWQgMCByb3dzIF0NCmNvbm49 NTI1NTk5OTIsIFNRTERyaXZlckNvbm5lY3Qob3V0KT0nRFNOPVBvc3RncmVTUUw7REFUQUJB U0U9aHlnZWE7U0VSVkVSPXZlcmRlO1BPUlQ9NTQzMjtVSUQ9bWFyY287UFdEPTtSRUFET05M WT0wO1BST1RPQ09MPTYuNDtGQUtFT0lESU5ERVg9MDtTSE9XT0lEQ09MVU1OPTA7Uk9XVkVS U0lPTklORz0xO1NIT1dTWVNURU1UQUJMRVM9MDtDT05OU0VUVElOR1M9c2V0K2tzcW8rdG8r JTI3b24lMjclM2InDQpjb25uPTUyNTU5OTkyLCBxdWVyeT0nU0VMRUNUIENvbmZpZywgblZh bHVlIEZST00gTVN5c0NvbmYnDQpFUlJPUiBmcm9tIGJhY2tlbmQgZHVyaW5nIHNlbmRfcXVl cnk6ICdFUlJPUjogIG1zeXNjb25mOiBUYWJsZSBkb2VzIG5vdCBleGlzdC4nDQpTVEFURU1F TlQgRVJST1I6IGZ1bmM9U0NfZXhlY3V0ZSwgZGVzYz0nJywgZXJybnVtPTEsIGVycm1zZz0n RXJyb3Igd2hpbGUgZXhlY3V0aW5nIHRoZSBxdWVyeScNCiAgICAgICAgICAgICAgICAgLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tDQogICAgICAgICAgICAgICAgIGhkYmM9NTI1NTk5OTIsIHN0bXQ9NTI1NzQ1MjAsIHJl c3VsdD0wDQogICAgICAgICAgICAgICAgIG1hbnVhbF9yZXN1bHQ9MCwgcHJlcGFyZT0wLCBp bnRlcm5hbD0wDQogICAgICAgICAgICAgICAgIGJpbmRpbmdzPTAsIGJpbmRpbmdzX2FsbG9j YXRlZD0wDQogICAgICAgICAgICAgICAgIHBhcmFtZXRlcnM9MCwgcGFyYW1ldGVyc19hbGxv Y2F0ZWQ9MA0KICAgICAgICAgICAgICAgICBzdGF0ZW1lbnRfdHlwZT0wLCBzdGF0ZW1lbnQ9 J1NFTEVDVCBDb25maWcsIG5WYWx1ZSBGUk9NIE1TeXNDb25mJw0KICAgICAgICAgICAgICAg ICBzdG10X3dpdGhfcGFyYW1zPSdTRUxFQ1QgQ29uZmlnLCBuVmFsdWUgRlJPTSBNU3lzQ29u ZicNCiAgICAgICAgICAgICAgICAgZGF0YV9hdF9leGVjPS0xLCBjdXJyZW50X2V4ZWNfcGFy YW09LTEsIHB1dF9kYXRhPTANCiAgICAgICAgICAgICAgICAgY3VyclR1cGxlPS0xLCBjdXJy ZW50X2NvbD0tMSwgbG9ial9mZD0tMQ0KICAgICAgICAgICAgICAgICBtYXhSb3dzPTAsIHJv d3NldF9zaXplPTEsIGtleXNldF9zaXplPTAsIGN1cnNvcl90eXBlPTAsIHNjcm9sbF9jb25j dXJyZW5jeT0xDQogICAgICAgICAgICAgICAgIGN1cnNvcl9uYW1lPSdTUUxfQ1VSMDMyMjM5 MzgnDQogICAgICAgICAgICAgICAgIC0tLS0tLS0tLS0tLS0tLS1RUmVzdWx0IEluZm8gLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KQ09OTiBFUlJPUjogZnVuYz1TQ19leGVj dXRlLCBkZXNjPScnLCBlcnJudW09MTEwLCBlcnJtc2c9J0VSUk9SOiAgbXN5c2NvbmY6IFRh YmxlIGRvZXMgbm90IGV4aXN0LicNCiAgICAgICAgICAgIC0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KICAgICAgICAgICAg aGVudj01MzYxMjQzNiwgY29ubj01MjU1OTk5Miwgc3RhdHVzPTEsIG51bV9zdG10cz0xNg0K ICAgICAgICAgICAgc29jaz01MzYxMjQ1Miwgc3RtdHM9NTM2MDg1ODAsIGxvYmpfdHlwZT0t OTk5DQogICAgICAgICAgICAtLS0tLS0tLS0tLS0tLS0tIFNvY2tldCBJbmZvIC0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAgICAgICAgICAgIHNvY2tldD02MCwgcmV2ZXJz ZT0wLCBlcnJvcm51bWJlcj0wLCBlcnJvcm1zZz0nKG51bGwpJw0KICAgICAgICAgICAgYnVm ZmVyX2luPTUyNTY2MzIwLCBidWZmZXJfb3V0PTUyNTcwNDIwDQogICAgICAgICAgICBidWZm ZXJfZmlsbGVkX2luPTQyLCBidWZmZXJfZmlsbGVkX291dD0wLCBidWZmZXJfcmVhZF9pbj00 Mg0KY29ubj01MjU1OTk5MiwgcXVlcnk9J1NFTEVDVCAib3BlcmF0b3JpIi4iY29kaWNlIiBG Uk9NICJvcGVyYXRvcmkiICcNCiAgICBbIGZldGNoZWQgMyByb3dzIF0NCmNvbm49NTI1NTk5 OTIsIHF1ZXJ5PSdTRUxFQ1QgImNvZGljZSIsImNhcCIgIEZST00gIm9wZXJhdG9yaSIgIFdI RVJFICJjb2RpY2UiID0gJzEgICcnDQogICAgWyBmZXRjaGVkIDEgcm93cyBdDQpjb25uPTUy NTU5OTkyLCBxdWVyeT0nQkVHSU4nDQpjb25uPTUyNTU5OTkyLCBxdWVyeT0nVVBEQVRFICJv cGVyYXRvcmkiIFNFVCAiY2FwIj0nMScgV0hFUkUgImNvZGljZSIgPSAnMSAgJycNCmNvbm49 NTI1NTk5OTIsIHF1ZXJ5PSdTRUxFQ1QgImNvZGljZSIsImNhcCIgIEZST00gIm9wZXJhdG9y aSIgIFdIRVJFICJjb2RpY2UiID0gJzMgICcnDQogICAgWyBmZXRjaGVkIDEgcm93cyBdDQpj b25uPTUyNTU5OTkyLCBxdWVyeT0nVVBEQVRFICJvcGVyYXRvcmkiIFNFVCAiY2FwIj0nMScg V0hFUkUgImNvZGljZSIgPSAnMyAgJycNCmNvbm49NTI1NTk5OTIsIHF1ZXJ5PSdTRUxFQ1Qg ImNvZGljZSIsImNhcCIgIEZST00gIm9wZXJhdG9yaSIgIFdIRVJFICJjb2RpY2UiID0gJzIg ICcnDQogICAgWyBmZXRjaGVkIDEgcm93cyBdDQpjb25uPTUyNTU5OTkyLCBxdWVyeT0nVVBE QVRFICJvcGVyYXRvcmkiIFNFVCAiY2FwIj0nMScgV0hFUkUgImNvZGljZSIgPSAnMiAgJycN CmNvbm49NTI1NzQ1MjAsIFNRTERyaXZlckNvbm5lY3QoIGluKT0nRFNOPVBvc3RncmVTUUw7 VUlEPW1hcmNvO1BXRD07REFUQUJBU0U9aHlnZWE7U0VSVkVSPXZlcmRlO1BPUlQ9NTQzMjtS RUFET05MWT0wO1BST1RPQ09MPTtGQUtFT0lESU5ERVg9MDtTSE9XT0lEQ09MVU1OPTA7Uk9X VkVSU0lPTklORz0wO1NIT1dTWVNURU1UQUJMRVM9MDtDT05OU0VUVElOR1M9c2V0K2tzcW8r dG8rJTI3b24lMjclM2I7JywgZkRyaXZlckNvbXBsZXRpb249MA0KRFNOIGluZm86IERTTj0n UG9zdGdyZVNRTCcsc2VydmVyPSd2ZXJkZScscG9ydD0nNTQzMicsZGJhc2U9J2h5Z2VhJyx1 c2VyPSdtYXJjbycscGFzc3dkPScnDQogICAgICAgICAgcmVhZG9ubHk9JzAnLHByb3RvY29s PSc2LjQnLHNob3dvaWQ9JzAnLGZha2VvaWRpbmRleD0nMCcsc2hvd3N5c3RhYmxlPScwJw0K ICAgICAgICAgIGNvbm5fc2V0dGluZ3M9J3NldCBrc3FvIHRvICdvbic7Jw0KICAgICAgICAg IHRyYW5zbGF0aW9uX2RsbD0nJyx0cmFuc2xhdGlvbl9vcHRpb249JycNCkdsb2JhbCBPcHRp b25zOiBWZXJzaW9uPScwNi40MC4wMDA0JywgZmV0Y2g9MTAwLCBzb2NrZXQ9NDA5NiwgdW5r bm93bl9zaXplcz0yLCBtYXhfdmFyY2hhcl9zaXplPTI1NCwgbWF4X2xvbmd2YXJjaGFyX3Np emU9NDA5NA0KICAgICAgICAgICAgICAgIGRpc2FibGVfb3B0aW1pemVyPTAsIGtzcW89MSwg dW5pcXVlX2luZGV4PTEsIHVzZV9kZWNsYXJlZmV0Y2g9MA0KICAgICAgICAgICAgICAgIHRl eHRfYXNfbG9uZ3ZhcmNoYXI9MSwgdW5rbm93bnNfYXNfbG9uZ3ZhcmNoYXI9MSwgYm9vbHNf YXNfY2hhcj0wDQogICAgICAgICAgICAgICAgZXh0cmFfc3lzdGFibGVfcHJlZml4ZXM9J2Rk XzsnLCBjb25uX3NldHRpbmdzPScNDQoNDQonDQpjb25uPTUyNTc0NTIwLCBxdWVyeT0nICcN CmNvbm49NTI1NzQ1MjAsIHF1ZXJ5PSdzZXQgRGF0ZVN0eWxlIHRvICdJU08nJw0KY29ubj01 MjU3NDUyMCwgcXVlcnk9J3NldCBrc3FvIHRvICdPTicnDQpjb25uPTUyNTc0NTIwLCBxdWVy eT0nDQoNCicNCmNvbm49NTI1NzQ1MjAsIHF1ZXJ5PSdzZXQga3NxbyB0byAnb24nJw0KY29u bj01MjU3NDUyMCwgcXVlcnk9J3NlbGVjdCBvaWQgZnJvbSBwZ190eXBlIHdoZXJlIHR5cG5h bWU9J2xvJycNCiAgICBbIGZldGNoZWQgMCByb3dzIF0NCmNvbm49NTI1NzQ1MjAsIFNRTERy aXZlckNvbm5lY3Qob3V0KT0nRFNOPVBvc3RncmVTUUw7REFUQUJBU0U9aHlnZWE7U0VSVkVS PXZlcmRlO1BPUlQ9NTQzMjtVSUQ9bWFyY287UFdEPTtSRUFET05MWT0wO1BST1RPQ09MPTYu NDtGQUtFT0lESU5ERVg9MDtTSE9XT0lEQ09MVU1OPTA7Uk9XVkVSU0lPTklORz0wO1NIT1dT WVNURU1UQUJMRVM9MDtDT05OU0VUVElOR1M9c2V0K2tzcW8rdG8rJTI3b24lMjclM2InDQpj b25uPTUyNTc0NTIwLCBxdWVyeT0nU0VMRUNUICJvcGVyYXRvcmkiLiJjb2RpY2UiIEZST00g Im9wZXJhdG9yaSIgJw0K --------------091198F5249071AFA7AC7535--