Re: nested xacts and phantom Xids - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: nested xacts and phantom Xids
Date
Msg-id 200406210017.i5L0HZL28396@candle.pha.pa.us
Whole thread Raw
In response to Re: nested xacts and phantom Xids  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: nested xacts and phantom Xids  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.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.

And your point is?   I am trying to help Alvaro.  I came up with an
idea, and some thought it would help solve the problem.  What ideas do
you have to help him?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-patches by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Tablespaces
Next
From: Andrew Dunstan
Date:
Subject: Re: [pgsql-hackers-win32] Data directory with trailing [back]slash