Re: Nested transactions - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Nested transactions
Date
Msg-id 20091013000819.GC5954@alvh.no-ip.org
Whole thread Raw
In response to Re: Nested transactions  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
Jeff Davis escribió:
> On Mon, 2009-10-12 at 16:18 -0700, Bill Todd wrote:
> > Savepoints do not provide the same functionality as nested or parallel
> > transactions because you cannot commit a savepoint.
>
> What does it mean to "commit" a subtransaction or savepoint? What can
> you do with a subtransaction that you can't do with a savepoint?

What Bill wants is an "autonomous" transaction.  We don't have those yet
(except thru use of dblink or database connections inside a function.)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Nested transactions
Next
From: Dan Kortschak
Date:
Subject: `must be superuser to COPY to or from a file' - using perl DBI - approaches to work around this