Re: What happens If a table changes during a query/procedure execution

From: Nicolas Barbier <nicolas(dot)barbier(at)gmail(dot)com>
To: Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)ru>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: What happens If a table changes during a query/procedure execution
Date: 2011-03-09 10:57:45
Message-ID: AANLkTikyxrn8FVe38VMnO-wtX5otDFypbcMZMSoZ4xLH@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2011/3/9 Nicolas Barbier <nicolas(dot)barbier(at)gmail(dot)com>:

> Note that the standard defines things that must never happen in the
> case of READ COMMITTED, it does not specify that one *must* be able to
> see the stuff as committed by previous transactions, for example.

Hmm, make that "stuff as committed by concurrent transactions that
committed prior to our statement's execution".

Nicolas

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2011-03-09 11:11:17 Update of replication/README
Previous Message Nicolas Barbier 2011-03-09 10:54:48 Re: What happens If a table changes during a query/procedure execution