Re: [HACKERS] Transaction control in procedures - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] Transaction control in procedures
Date
Msg-id 77562d14-877b-0f32-9790-fca0f8af8c4e@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] Transaction control in procedures  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: [HACKERS] Transaction control in procedures  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
On 11/15/17 09:54, Merlin Moncure wrote:
> ... I noticed that:
> *) now() did not advance with commit and,
> *) xact_start via pg_stat_activity did not advance
> 
> Shouldn't both of those advance with the in-loop COMMIT?

I think you are correct.  I'll include that in the next patch version.
It shouldn't be difficult.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: Updated macOS start scripts
Next
From: Tom Lane
Date:
Subject: Re: Further simplification of c.h's #include section