Skip site navigation (1) Skip section navigation (2)

Re: Nested xacts: looking for testers and review

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Nested xacts: looking for testers and review
Date: 2004-05-29 00:43:41
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Wed, 26 May 2004, Alvaro Herrera wrote:

> I have tested it and it passes all regression tests (including ones I
> added), plus some more tests I threw at it mainly for concurrency.
> Everything behaves as expected.  At this time I'd like to have it
> reviewed by the critic eye of the committers, and tested by whoever
> would be using it.
> I'm open for comments and suggestions and general input.  Thank you.

I unfortunately didn't really follow the discussions in the past (sorry :(
), but are the transaction state modifying statements done in a
subtransaction supposed to live beyond subtransaction rollback?

For example,
sszabo=# begin;
sszabo=# begin;
sszabo=# set transaction read only;
sszabo=# select * from a;
(1 row)

sszabo=# rollback;
sszabo=# update a set a=6;
ERROR:  transaction is read-only

In response to


pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2004-05-29 01:01:34
Subject: Re: Nested xacts: looking for testers and review
Previous:From: Gaetano MendolaDate: 2004-05-29 00:13:30
Subject: false infinite recursion detected

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group