On Sun, 2009-07-26 at 19:15 -0400, Science wrote:
> FWIW, the way the Rails ORM ActiveRecord (another fairly damaged ORM)
> handles this is by allowing you to open any number of transaction
> blocks, but only the outer transaction block commits (in Pg):
>
> Property.transaction { # SQL => 'BEGI
Date: Thu, 23 Jul 2009 09:06:50 +0100
From: Richard Huxton
To: Glenn Maynard
Cc: pgsql-sql@postgresql.org
Subject: Re: Bit by "commands ignored until end of transaction block"
again
Message-ID: <4a681a1a.1090...@archonet.com>
Glenn Maynard wrote:
On Thu, Jul 23, 2009 at 2:41 AM, Richar
> The above situation only arises if you run in autocommit mode which is the
> default for psql (which I have *never* understood).
This is the short answer, in practice--assume that either a
transaction is started or will be started by the SAVEPOINT command,
and that if a COMMIT is needed (as a r
