From: Herouth Maoz <herouth@oumail.openu.ac.il>
To: Matthew Hagerty <matthew@venux.net>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Proper use of Transactions...
Date: Mon, 9 Aug 1999 11:09:43 +0300
Message-ID: <l03130300b3d43c2fef72@[147.233.159.109]> (raw)
In-Reply-To: <4.1.19990808155400.009f43c0@mail.venux.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-interfaces@postgresql.org
Cc: herouth@oumail.openu.ac.il, matthew@venux.net
Subject: Re: [INTERFACES] Proper use of Transactions...
In-Reply-To: <l03130300b3d43c2fef72@[147.233.159.109]>
References: <4.1.19990808155400.009f43c0@mail.venux.net> <l03130300b3d43c2fef72@[147.233.159.109]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox