Wolfgang Wilhelm schrieb am 05.11.2014 um 09:08: > 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. You can use \set AUTOCOMMIT off in psql to turn off autocommit mode (note that this is case-sensitive!) I have that line in my psqlrc file so autocommit is automatically turned off. (although I rarely use psql or sqlplus) Regards Thomas -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
