Received: from redbox.venux.net (redbox.venux.net [216.47.238.10]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA91388 for ; Sun, 8 Aug 1999 16:38:33 -0400 (EDT) (envelope-from matthew@venux.net) Received: from thunder (net177138.hcv.com [209.153.177.138]) by redbox.venux.net (Postfix) with SMTP for id CDE452E20B; Sun, 8 Aug 1999 16:38:28 -0400 (EDT) Message-Id: <4.1.19990808155400.009f43c0@mail.venux.net> X-Sender: mhagerty@mail.venux.net X-Mailer: QUALCOMM Windows Eudora Pro Version 4.1 Date: Sun, 08 Aug 1999 16:38:23 -0400 To: pgsql-interfaces@postgresql.org From: Matthew Hagerty Subject: Proper use of Transactions... Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Greetings, If I write a transaction like this: begin transaction; . . . commit transaction; and an error occurs somewhere in the middle, do I have to issue a rollback command or will PostgreSQL do that automatically on an error? The problem I think I am having is that if some command between the begin and commit statements causes an error, my program terminates, so I do not have an opportunity to issue a rollback. All this is compounded because I am using PHP3 as an Apache module to access PostgreSQL and I am receiving the following error in my Apache log: NOTICE: (transaction aborted): queries ignored until END I'm not sure where to start looking for the problem. Any insight would be greatly appreciated. Thank you, Matthew