Re: Nested transactions

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Nested transactions
Дата
Msg-id 20091013000819.GC5954@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Nested transactions  (Jeff Davis <pgsql@j-davis.com>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Nested transactions
Следующее
От: Dan Kortschak
Дата:
Сообщение: `must be superuser to COPY to or from a file' - using perl DBI - approaches to work around this