From: Wolfgang Wilhelm <wolfgang20121964@yahoo.de>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Autocommit off in psql
Date: Wed, 5 Nov 2014 08:08:32 +0000 (UTC)
Message-ID: <1317404836.812502.1415174912912.JavaMail.yahoo@jws11120.mail.ir2.yahoo.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: wolfgang20121964@yahoo.de
Subject: Re: Autocommit off in psql
In-Reply-To: <1317404836.812502.1415174912912.JavaMail.yahoo@jws11120.mail.ir2.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox