Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Paquier
Subject Re: transction_timestamp() inside of procedures
Date
Msg-id 20180921053425.GM1338@paquier.xyz
Whole thread Raw
In response to Re: transction_timestamp() inside of procedures  (Andres Freund <andres@anarazel.de>)
Responses Re: transction_timestamp() inside of procedures  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Tree view 
On Thu, Sep 20, 2018 at 10:12:06PM -0700, Andres Freund wrote:
> Isn't the point that transaction_timestamp() does *not* currently change
> its value, even though the transaction (although not the outermost
> statement) has finished?

Ouch, yes.  I see the point now.  Indeed that's strange to not have a
new transaction timestamp after commit within the DO block..

I need a break of a couple of minutes.
--
Michael
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Function to promote standby servers
Next
From: "Tsunakawa, Takayuki"
Date:
Subject: RE: Changing the setting of wal_sender_timeout per standby