Re: nested xacts and phantom Xids

Tom Lane wrote:
> 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.

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073