From: Matthew Hagerty <matthew@venux.net>
To: pgsql-interfaces@postgresql.org
Subject: Proper use of Transactions...
Date: Sun, 08 Aug 1999 16:38:23 -0400
Message-ID: <4.1.19990808155400.009f43c0@mail.venux.net> (raw)
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
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: matthew@venux.net
Subject: Re: Proper use of Transactions...
In-Reply-To: <4.1.19990808155400.009f43c0@mail.venux.net>
* 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