Re: transction_timestamp() inside of procedures - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: transction_timestamp() inside of procedures
Date
Msg-id 20180921045536.GJ1338@paquier.xyz
Whole thread Raw
In response to transction_timestamp() inside of procedures  (Bruce Momjian <bruce@momjian.us>)
Responses Re: transction_timestamp() inside of procedures  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On Thu, Sep 20, 2018 at 07:40:40PM -0400, Bruce Momjian wrote:
> This surprised me since I expected a new timestamp after commit.  Is
> this something we want to change or document?  Are there other
> per-transaction behaviors we should adjust?

I don't quite follow your argument here.  clock_timestamp is known to be
volatile, while the two others are stable, so its value can change
within a transaction.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Proposal for Signal Detection Refactoring
Next
From: Andres Freund
Date:
Subject: Re: transction_timestamp() inside of procedures