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

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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: nested-all-15.patch.gz
Description: application/octet-stream (53.1 KB)

In response to

Responses

pgsql-hackers by date

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

pgsql-patches by date

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

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