Re: nested xacts and phantom Xids

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: nested xacts and phantom Xids
Date: 2004-06-26 04:42:28
Message-ID: 20040626044227.GB1865@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

I said

> I'll post a full patch once the missing deferred trigger stuff works.
> With the patches I posted to inval.c I think this fulfills the
> requirements, barring the performance issues raised.

Ok, here is a full patch that includes:

- all what was in the previous patch
- GUC vars are rolled back on subxact abort
- the inval msg lists are cleaned up of items created in the aborting
subxact
- SET CONSTRAINTS is rolled back too

Missing:

- all the other items Tom mentioned in his last mail, including
performance enhancements.

- discussion whether we want a different syntax for subxacts, like
SUBBEGIN/SUBCOMMIT/SUBABORT instead of BEGIN/COMMIT/ABORT. Please
comment on this point.

- support for SAVEPOINT syntax.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La grandeza es una experiencia transitoria. Nunca es consistente.
Depende en gran parte de la imaginación humana creadora de mitos"
(Irulan)

Attachment Content-Type Size
nested-all-15.patch.gz application/octet-stream 53.1 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2004-06-26 04:49:11 Re: [PATCHES] nested xacts and phantom Xids
Previous Message Christopher Kings-Lynne 2004-06-26 04:37:42 Re: [COMMITTERS] pgsql-server: Support renaming of tablespaces,

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2004-06-26 04:49:11 Re: [PATCHES] nested xacts and phantom Xids
Previous Message Tom Lane 2004-06-25 22:12:57 Re: Include tablespace information in psql \d footers