Received: from mx99.openu.ac.il (arbel.openu.ac.il [147.233.32.4]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA81149 for ; Mon, 9 Aug 1999 04:08:44 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from talmon.openu.ac.il (talmon.openu.ac.il [147.233.32.11]) by mx99.openu.ac.il (Postfix) with ESMTP for id 2FC004B597; Mon, 9 Aug 1999 11:08:38 +0300 (IDT) Received: from [147.233.159.109] (mac-herouth.pc.openu.ac.il) by talmon.openu.ac.il (Netscape Messaging Server 3.54) with ESMTP id AAA1923; Mon, 9 Aug 1999 11:12:08 +0300 X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <4.1.19990808155400.009f43c0@mail.venux.net> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Mon, 9 Aug 1999 11:09:43 +0300 To: Matthew Hagerty , pgsql-interfaces@postgreSQL.org From: Herouth Maoz Subject: Re: [INTERFACES] Proper use of Transactions... At 23:38 +0300 on 08/08/1999, Matthew Hagerty wrote: > 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. This is just normal. It indicates that since an error has occured, the rest of the commands in the transaction, if they are issued, will be ignored - untill you say either "commit" or "rollback". It gives you the effect of not doing anything more in a transaction if an error occured in the middle of it. If errors which are not database errors occur in the middle (for example, you run a validity test on the user's data and it fails), you should catch those errors and issue a rollback yourself. This has nothing to do with the type of interface you are using (in your case PHP3), unless that interface does not allow you to make validity tests or to capture errors. I don't think there is damage to the database if a transaction is not committed or rolled back before the connection terminates - but a guru opinion would have more value than mine. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma