| From: | Wolfgang Wilhelm <wolfgang20121964(at)yahoo(dot)de> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Autocommit off in psql |
| Date: | 2014-11-05 08:08:32 |
| Message-ID: | 1317404836.812502.1415174912912.JavaMail.yahoo@jws11120.mail.ir2.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2014-11-05 08:24:40 | Re: Autocommit off in psql |
| Previous Message | jayknowsunix | 2014-11-05 02:02:52 | Re: xlog-cleanup problem |