Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 1E0E89FBDF0 for ; Thu, 1 Mar 2007 10:48:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 82958-08 for ; Thu, 1 Mar 2007 10:48:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.unl.edu.ar (mail.unl.edu.ar [168.96.132.10]) by postgresql.org (Postfix) with SMTP id 15C239FBDDD for ; Thu, 1 Mar 2007 10:48:51 -0400 (AST) Received: (qmail 21125 invoked by uid 1010); 1 Mar 2007 14:48:36 -0000 Received: from 168.96.132.199 by scanner-pc-m- (envelope-from , uid 1002) with qmail-scanner-0.2 (sophie: 3.04/2.38/4.10. spamassassin: 3.1.0-rc2. perlscan: 0.2. Clear:RC:1(168.96.132.199):. Processed in 0.103741 secs); 01 Mar 2007 14:48:36 -0000 Received: from xennon.unl.edu.ar (HELO ?192.168.1.68?) (168.96.132.199) by mail.unl.edu.ar with SMTP; 1 Mar 2007 14:48:36 -0000 Message-ID: <45E6E7CB.3060800@bugs.unl.edu.ar> Date: Thu, 01 Mar 2007 11:48:43 -0300 From: Martin Marques User-Agent: Icedove 1.5.0.9 (X11/20061220) MIME-Version: 1.0 To: John DeSoi CC: mikie , pgsql-php@postgresql.org Subject: Re: transactions from PHP - double COMMIT required? References: <20070301131523.fgfm83nb9y2kgo4c@imp3.uta.fi> <59D024F7-8F90-4FD0-B8A9-A58C85CC014F@pgedit.com> In-Reply-To: <59D024F7-8F90-4FD0-B8A9-A58C85CC014F@pgedit.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.01 tagged_above=0 required=5 tests=AWL, BAYES_50 X-Spam-Level: X-Archive-Number: 200703/12 X-Sequence-Number: 3724 John DeSoi wrote: > The client must issue a command to commit or rollback the transaction. > > In your example, are you sending all of the SQL lines (including the > COMMIT) as a single execution? It sounds like the interface stops > executing as soon as an error is reached. So perhaps change your code to > execute the COMMIT separately after all the other commands have executed. Logs would also help. -- 21:50:04 up 2 days, 9:07, 0 users, load average: 0.92, 0.37, 0.18 --------------------------------------------------------- Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador ---------------------------------------------------------