Re: pg_stat_statements vs. SELECT FOR UPDATE

Vik Fearing <vik.fearing@2ndquadrant.com>

From: Vik Fearing <vik.fearing@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andrew Gierth <andrew@tao11.riddles.org.uk>, pgsql-hackers@lists.postgresql.org
Date: 2019-01-20T01:11:19Z
Lists: pgsql-hackers

Attachments

On 19/01/2019 18:02, Tom Lane wrote:
> Vik Fearing <vik.fearing@2ndquadrant.com> writes:
>> Does the extension need a version bump for this?
> 
> We don't bump its version when we make any other change that affects
> its hash calculation.  I don't think this could be back-patched,
> but Andrew wasn't proposing to do so (IIUC).

OK perfect.

Here is Andrew's original patch, but with some tests.
-- 
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

Commits

  1. Teach pg_stat_statements not to ignore FOR UPDATE clauses