Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id WAA88979 for ; Wed, 15 Dec 1999 22:43:04 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id WAA23220; Wed, 15 Dec 1999 22:42:32 -0500 (EST) To: Barry Baldwin cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] TRANSACTIONS and TCP/IP In-reply-to: Your message of Wed, 15 Dec 1999 16:38:44 -0800 <319A9588FB5ED2119FAC00A0C912E3292785A8@INDYMEEXCH> Date: Wed, 15 Dec 1999 22:42:32 -0500 Message-ID: <23218.945315752@sss.pgh.pa.us> From: Tom Lane Barry Baldwin writes: > 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. I don't know anything about Delphi, but it sure sounds like something in the interface software you're using is sending BEGIN and COMMIT commands for you. This feature is commonly called autocommit --- look for documentation on how to turn it off. > 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? No, connection type hasn't got anything to do with it... regards, tom lane