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

Re: nested xacts and phantom Xids

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>,Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Subject: Re: nested xacts and phantom Xids
Date: 2004-06-20 21:43:48
Message-ID: 10281.1087767828@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Let me add that outside transactions read those phantom xid only when
> they are doing dirty reads.  What I don't understand is when do outside
> transactions see tuples created inside a transaction?  INSERT into a
> table with a unique key?

> Once the main transaction commits, these phantom tuples should work just
> like ordinary tuples except they get their cmin overwritten when they
> are expired, I think.

You're not doing anything to increase my confidence level in this
concept.  You invented it, and even you aren't sure how it works.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2004-06-20 22:27:31
Subject: Re: Tablespaces
Previous:From: Tom LaneDate: 2004-06-20 21:34:41
Subject: Re: nested xacts and phantom Xids

pgsql-patches by date

Next:From: Andrew DunstanDate: 2004-06-20 22:07:40
Subject: Re: Data directory with trailing [back]slash
Previous:From: Tom LaneDate: 2004-06-20 21:34:41
Subject: Re: nested xacts and phantom Xids

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