Request a Demo
Home   >   mailing lists

Re: Volatility of pg_xact_commit_timestamp() and pg_last_committed_xact() - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Volatility of pg_xact_commit_timestamp() and pg_last_committed_xact()
Date
Msg-id CA+TgmoaGpd=YvhLyf8MNDnJW56U=pROgdPrFxyeLhc2Qx+LPGA@mail.gmail.com
Whole thread Raw
In response to Volatility of pg_xact_commit_timestamp() and pg_last_committed_xact()  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: Volatility of pg_xact_commit_timestamp() and pg_last_committed_xact()
List pgsql-hackers
Tree view 
On Thu, Jul 16, 2015 at 9:49 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
> Volatilities of pg_xact_commit_timestamp() and pg_last_committed_xact()
> are now STABLE. But ISTM that those functions can return different results
> even within a single statement. So we should change the volatilities of them
> to VOLATILE?

Sounds right to me.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: brin index vacuum versus transaction snapshots
Next
From: Jolly Chen
Date:
Subject: "A huge debt of gratitude" - Michael Stonebraker