Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xlve8-0006lH-0U for pgsql-admin@arkaria.postgresql.org; Wed, 05 Nov 2014 08:08:52 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Xlve7-0007wW-Gj for pgsql-admin@arkaria.postgresql.org; Wed, 05 Nov 2014 08:08:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Xlve6-0007wP-BI for pgsql-admin@postgresql.org; Wed, 05 Nov 2014 08:08:50 +0000 Received: from nm33-vm3.bullet.mail.ir2.yahoo.com ([212.82.97.108]) by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1Xlvdx-0003Jg-KB for pgsql-admin@postgresql.org; Wed, 05 Nov 2014 08:08:48 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.de; s=s2048; t=1415174919; bh=fhdBVt+Bi9QJr8tjys6fTBA4a1s2uiO0QEWIIbUIPbk=; h=Date:From:Reply-To:To:Subject:From:Subject; b=W7wlSVi4YD2GG3IsHbaac1Z7Qz+Bka0G4E0hmNSyIFSZidNlVuY9vQRTKSYeUbhfWmduX0x9wPNM41AlNyjMHgz1sorJAeC1r/KdfHwxW4ilg2qDSfMQ9VodE5c6e+wAeS8IJxhr3PZNMFLQ8AT+otVVLH8YMW1RNC7iG6/3tEMTPlLq5ECbpZH+sIdDKP7KtaSxm8BItzwh/82O+BnjqVrg8O0y1CBpDdFmDFR5pgD4Sntk+cKiZBgzEG7vh5TRYnr9JagpLuPRpeeAedRlMYa9b/QY1TA9f0A1baoo/c+ccK7v2jpmc6NRRedE5sNH36T0e+RuxKE2gBw1daSPhw== DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s2048; d=yahoo.de; b=b3FGRKK/gNnDofDx1ah8imWAzkF2atSrg4/ylbMDngngrnEze4Bs/YuCl6RZKeBRy+M6Vy7MQ/htNy80UOmC/tqmU/m3xuAqkhMBSBOfdELeBVlQMaIeYroS3SnwOGwNreilQuKl+kGQ31u9THYgdqABKvPtwPjdUMyY4Z8+/uU9Ac22oh+B3g2yO2906YIqwOQZZVUT9qysCYLS7Ya62ka+WxfBFBOxzlrMpg6V6RXRn2T5a7RYlciRXv2/Fpg+n6bagrPDAvp2j2xOgCCHrsAy0DpadzHaoMd53ErX50py3s3d7PwB3wfBFMJkfDNl6HEGOb1LMuVKWjVT53ohFw==; Received: from [212.82.98.127] by nm33.bullet.mail.ir2.yahoo.com with NNFMP; 05 Nov 2014 08:08:39 -0000 Received: from [212.82.98.108] by tm20.bullet.mail.ir2.yahoo.com with NNFMP; 05 Nov 2014 08:08:39 -0000 Received: from [127.0.0.1] by omp1045.mail.ir2.yahoo.com with NNFMP; 05 Nov 2014 08:08:39 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 268085.70342.bm@omp1045.mail.ir2.yahoo.com X-YMail-OSG: ZEjIbFEVM1mR0SPWf6xlMxZyWgTPi3Jcu5COTae1PeRBVoJsW01Hx4VNMa9ORIm NbNBCqx.NTo_RSLNf.a6iCWyrPQvKSKKCpv_WkfGpwm1CJJWKIVSHHhqtaslzK9NglzWsBy4F2KH xHUf8vqWVw5ja4EFTrnS_fJZegX5bV2iTTPkb6AAaQr.0rBHhZfrO5YPjhU5unMNmq6BAg1F0EJB jYv2xqImvcpWALSEdxqvZVrwU_wrplSKuV8VBdZ.57888SkLD8kcjPx.5FkBhqRGXsRyuQPgDYFA 8d0yoBLb1KqYEMIsvthNl23a0bqJQtmJv6pn4DLP7jcnxVsCaJhTdEhMEAYXzDId0DgjiuPQXpZP VmATTqTHy0LljmVPBZVQWHs2mZKnUblcQU7r5KOYcZdEubK5mLjtb64Qwd5eiCwlCBE5qesfvFrx iRGCa.4kHdzoLnQ7Zt7nhmMnmnMqnyLEm9bvEYp7MKP9yt7BUtcUUqg4YU80oGkDxehmgPJDpegh o.w-- Received: by 212.82.98.117; Wed, 05 Nov 2014 08:08:38 +0000 Date: Wed, 5 Nov 2014 08:08:32 +0000 (UTC) From: Wolfgang Wilhelm Reply-To: Wolfgang Wilhelm To: "pgsql-admin@postgresql.org" Message-ID: <1317404836.812502.1415174912912.JavaMail.yahoo@jws11120.mail.ir2.yahoo.com> Subject: Autocommit off in psql MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_812501_1007155090.1415174912908" Content-Length: 2725 X-Pg-Spam-Score: -1.5 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ------=_Part_812501_1007155090.1415174912908 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Hello there, we are using Pg 9.3.4. My developers will have to transform an Oracle database application to PG. Some of them will switch from sqlplus to psql. There's an annoying difference between the database command line tools.Oracle doesn't have a BEGIN for a transaction start but needs a commit for saving changes. Psql on the other hand requires BEGIN to start an transaction or it will be in autocommit mode. Guess how much not so nice words I've heard in the last days because my team forgets that transaction begin... Is there any way to make psql work a little bit more like sqlplus? "Set autocommit off" is obviously no solution as it's not valid anymore. Maybe there is another more sqlplus-ish tool? RegardsWolfgang ------=_Part_812501_1007155090.1415174912908 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello there,

we are using Pg 9.3.4. My developers wi= ll have to transform an Oracle database application to PG. Some of them wil= l switch from sqlplus to psql.

There's an annoying difference between the database command lin= e tools.
Oracl= e doesn't have a BEGIN for a transaction start but needs a commit for savin= g changes. Psql on the other hand requires BEGIN to start an transaction or= it will be in autocommit mode. Guess how much not so nice words I've heard= in the last days because my team forgets that transaction begin...

Is there any way to make p= sql work a little bit more like sqlplus? "Set autocommit off" is obviously = no solution as it's not valid anymore. Maybe there is another more sqlplus-= ish tool?
=
Regards
Wolfgang

------=_Part_812501_1007155090.1415174912908--