From: Jaime Casanova <systemguards@gmail.com>
To: Mark Lewis <mark.lewis@mir3.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Savepoint performance
Date: Thu, 27 Jul 2006 19:52:24 -0500
Message-ID: <c2d9e70e0607271752j6ce91a90ld199c7a0d752fc62@mail.gmail.com> (raw)
In-Reply-To: <1154020755.1634.509.camel@archimedes>
References: <1154020755.1634.509.camel@archimedes>
On 7/27/06, Mark Lewis <mark.lewis@mir3.com> wrote:
> All,
>
> I support a system that runs on several databases including PostgreSQL.
> I've noticed that the other DB's always put an implicit savepoint before
> each statement executed, and roll back to that savepoint if the
> statement fails for some reason. PG does not, so unless you manually
> specify a savepoint you lose all previous work in the transaction.
>
you're talking about transactions not savepoints (savepoints is
something more like nested transactions), i guess...
postgres execute every single statement inside an implicit transaction
unless you put BEGIN/COMMIT between a block of statements... in that
case if an error occurs the entire block of statements must
ROLLBACK...
if other db's doesn't do that, is a bug in their implementation of the
SQL standard
--
regards,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook
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-performance@postgresql.org
Cc: systemguards@gmail.com, mark.lewis@mir3.com
Subject: Re: Savepoint performance
In-Reply-To: <c2d9e70e0607271752j6ce91a90ld199c7a0d752fc62@mail.gmail.com>
* 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