X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4DA2D3A2BF6 for ; Sat, 15 Jan 2005 10:41:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99428-04 for ; Sat, 15 Jan 2005 10:41:13 +0000 (GMT) Received: from laptop.kieser.net (kieser2.demon.co.uk [80.176.229.121]) by svr1.postgresql.org (Postfix) with ESMTP id D83033A2B75 for ; Sat, 15 Jan 2005 10:41:14 +0000 (GMT) Received: from [127.0.0.1] (laptop.kieser2.demon.co.uk [127.0.0.1]) by laptop.kieser.net (Postfix) with ESMTP id 5565318333; Sat, 15 Jan 2005 10:41:41 +0000 (GMT) Message-ID: <41E8F364.1010609@kieser.net> Date: Sat, 15 Jan 2005 10:41:40 +0000 From: Bradley Kieser User-Agent: Mozilla Thunderbird 0.8 (X11/20040913) X-Accept-Language: en, en-us MIME-Version: 1.0 To: Michael Fuhr Cc: PgSQL ADMIN Subject: Re: Script terminates even though ON_ERROR_STOP not set References: <41E7B4F6.8070505@kieser.net> <20050114175422.GA18434@winnie.fuhr.org> <41E80B4F.9040701@kieser.net> <20050115005600.GA47466@winnie.fuhr.org> In-Reply-To: <20050115005600.GA47466@winnie.fuhr.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.331 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/162 X-Sequence-Number: 16021 $ psql --version psql (PostgreSQL) 7.4.1 contains support for command-line editing # SELECT version(); version --------------------------------------------------------------------------------------------------------- PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk) (1 row) Michael Fuhr wrote: >On Fri, Jan 14, 2005 at 06:11:27PM +0000, Bradley Kieser wrote: > > > >>Okay, Michael gets that trophy! Thanks Michael, it needed a commit. >>However, this is odd. I get a "No transaction in progress" error coming >>out on the commit, but at least it works, so I am happy! >> >> > >What version of the client and server are you using? For the client >run "psql --version"; for the server execute "SELECT version();". >Where do you have autocommit set? PostgreSQL 7.4 removed autocommit >from the server and added it to the client; I wonder if you're using >differing client and server versions that are causing confusion. > > >