Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Greg Stark wrote:
> >
> > If you commit each update then your tuple might well be visible to other
> > transactions, how would you check that?
>
> You check the xmin/xmax using standard visibility rules.
Would that really find anything? Even putting aside your own transaction
wouldn't it pick up any older transaction that started before yours and is
still running? They can't really see it but short of actually looking at their
snapshots I don't think you can determine that.
--
greg
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
