X-Original-To: pgsql-admin@postgresql.org Received: from cartero.tissat.es (unknown [193.16.216.34]) by svr1.postgresql.org (Postfix) with ESMTP id 4A7FC5E47B4 for ; Tue, 24 Aug 2004 05:19:59 -0300 (ADT) Received: from capitular.tissat.es (capitular.tissat.es [193.16.216.39]) by cartero.tissat.es (Postfix) with ESMTP id 963871F4B5 for ; Tue, 24 Aug 2004 10:08:35 +0200 (CEST) Received: from tissat.es ([193.16.216.122]) by capitular.tissat.es (Netscape Messaging Server 3.6) with ESMTP id AAA28CD for ; Tue, 24 Aug 2004 10:18:51 +0200 Message-ID: <412AF993.5090201@tissat.es> Date: Tue, 24 Aug 2004 10:17:23 +0200 From: "Stephen Kennedy" Reply-To: skennedy@tissat.es Organization: Tissat User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: psql and autocommit References: <4129F3C0.7080102@aldratech.com> In-Reply-To: <4129F3C0.7080102@aldratech.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200408/225 X-Sequence-Number: 14620 Just a note to clarify sqlplus It does start in noautocommit as you say. However, it issues a commit when you exit (with quit, Ctrl-D or whatever) which is (in my opinion) incorrect, and very much worth taking into account when writing scripts for Oracle. I think it should automatically issue a rollback on exit. regards, Stephen. Radu-Adrian Popescu wrote: > Tsirkin Evgeny wrote: > [snip] > >> commit to my shell scripts.I beleave that automatically >> commiting the psql -c queries is very logical thing. > > > I'm sure there are people who disagree with that statement. For > instance Oracle's sqlplus starts in noautocommit by default. And I've > found that to be a good thing actually. > For what it's worth I also think default client policy may as well be > left unchanged, or there will be a lot of baffled people. > > Regards,