From: Rod Taylor <pg@rbt.ca>
To: Holger Jakobs <holger@jakobs.com>
Cc: sszabo@megazone.bigpanda.com
Cc: pgsql-sql@postgresql.org
Subject: Re: transaction processing after error in statement
Date: Mon, 10 Nov 2003 13:56:29 -0500
Message-ID: <1068490585.25089.7.camel@jester> (raw)
In-Reply-To: <200311101237.hAACbuJ12784@bg.bib.de>
References: <200311101237.hAACbuJ12784@bg.bib.de>
> be recovered either. When committing a transaction the effects of all
> operations that did not fail will be made permanent. This is how
> transaction processing is described in the literature.
I would be interested in reading that (URLs please) as I didn't see
anything in the spec that was interesting on this topic.
4.8.5 from Framework (part 01)
An SQL-transaction (transaction) is a sequence of executions of
SQL-statements that is atomic with respect to recovery. That is
to say: either the execution result is completely successful, or
it has no effect on any SQL-schemas or SQL-data.
The "execution result is completely successful" could certainly be used
to back up PostgreSQLs choice to force a rollback. However, it doesn't
differentiate between execution of what the user requested, and
execution of recovery procedures on the successful user elements.
Irregardless, I wish a commit on a failed transaction would throw an
error -- END is good enough for Rollback or Commit.
For PostgreSQL to implement this we need Savepoints or nested
transactions internally since in many cases data is physically written
in order to perform things like Foreign Key constraint checks.
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-sql@postgresql.org
Cc: pg@rbt.ca, holger@jakobs.com, sszabo@megazone.bigpanda.com
Subject: Re: transaction processing after error in statement
In-Reply-To: <1068490585.25089.7.camel@jester>
* 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