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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-patches by date

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