Received: from ibm.cicnet.ro (IDENT:root@braila.cicnet.ro [193.231.113.254]) by hub.org (8.9.3/8.9.3) with ESMTP id CAA28473 for ; Thu, 16 Dec 1999 02:03:55 -0500 (EST) (envelope-from george@cicnet.ro) Received: from cicnet.ro (george.cicnet.ro [193.231.113.93]) by ibm.cicnet.ro (8.8.7/8.8.7) with ESMTP id KAA18595; Thu, 16 Dec 1999 10:07:06 +0200 Message-ID: <38588EFD.97633C5D@cicnet.ro> Date: Thu, 16 Dec 1999 09:04:30 +0200 From: George Moga X-Mailer: Mozilla 4.51 [en] (Win95; I) X-Accept-Language: en MIME-Version: 1.0 To: Barry Baldwin , pgsql-sql@postgresql.org Subject: Re: [SQL] TRANSACTIONS and TCP/IP References: <319A9588FB5ED2119FAC00A0C912E3292785A8@INDYMEEXCH> Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit Barry Baldwin wrote: > Hi, > > I've got postgres 6.5.2 running on a Linux box and I'm developing a client > app in Delphi. The client sends SQL commands via TCP/IP. > I've tried starting a transaction by sending the BEGIN command and then I > update a table and then send a ROLLBACK command to try > and abort the transaction. It doesn't seem to be working. Even though I've > done a rollback the transaction still goes through. > > When I start the transaction I get this message on the Linux box console > NOTICE: BeginTransactionBlock and not in default state > > This indicates that there is a transaction already in process. I don't know > how that can be. > > When I issue the rollback command I get this message > NOTICE: UserAbortTransactionBlock and not in in-progress state > > This indicates that there is no transaction in progress. There sure should > be. > > I tried all of the above in psql and it works fine. Is this something that > just won't work over a TCP/IP connection? > > Any suggestions on how I can get transactions to work would be greatly > appreciated, > > TIA, > > Barry > > ************ I belive you use ODBC for conection. I never use PostgreSQL ODBC but in ACCESS ODBC if you want to use transaction, you must use, before your transaction: dbc set autocommit off where dbc is your database conection. After you finishing your transaction: dbc set autocommit on I hope this help you! Best regards, George Moga, george@cicnet.ro P.S. Sorry for my english.