Re: Re: [COMMITTERS] pgsql: Ensure age() returns a stable value rather than the latest value

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: [COMMITTERS] pgsql: Ensure age() returns a stable value rather than the latest value
Дата
Msg-id 6151.1336834512@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Re: [COMMITTERS] pgsql: Ensure age() returns a stable value rather than the latest value  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Re: [COMMITTERS] pgsql: Ensure age() returns a stable value rather than the latest value
Список pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> Case (2) is more complex than described. If we use XID always, then
> the so-say stable value could change mid way through a scan when the
> XID is assigned and would provide neither a stable, sensible nor a
> backwards compatible response.

No, that's entirely wrong.  The original behavior of the function
for case 2, which I am proposing we revert to,  is that it would
forcibly assign an XID when the transaction didn't already have one.
Subsequently, that value would be stable for the duraction of the xact.
        regards, tom lane


В списке pgsql-hackers по дате отправления: