pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Paquier <michael@paquier.xyz>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: pg_stat_statements: Add some tests for older versions still usab
Date: Sat, 02 Oct 2021 08:41:02 +0000
Message-ID: <E1mWaZq-0002jt-9b@gemulon.postgresql.org> (raw)

pg_stat_statements: Add some tests for older versions still usable

When the newest version is loaded, the backend would load objects from
the oldest complete SQL file (here 1.4) and then update to the latest
version with transition scripts (up to 1.9 currently).  This provides
some coverage for upgrades of pg_stat_statements, but there is no test
to show how things have changed across each version.

This adds a couple of tests for the upgrade paths using objects from
each version supported, stressing the objects whose behaviors have
changed across each version supported.

Author: Erica Zhang
Reviewed-by: Julien Rouhaud, Michael Paquier
Discussion: https://postgr.es/m/tencent_BBA974AFF61379F2345E782FD6C55891950A@qq.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/2b0da0365bec6c62cc9c5c317bab6cbee3d52ef4

Modified Files
--------------
contrib/pg_stat_statements/Makefile                |   2 +-
.../pg_stat_statements/expected/oldextversions.out | 139 +++++++++++++++++++++
contrib/pg_stat_statements/sql/oldextversions.sql  |  39 ++++++
3 files changed, 179 insertions(+), 1 deletion(-)



Message-ID: <E1mWaZq-0002jt-9b@gemulon.postgresql.org>
Permalink:  ../E1mWaZq-0002jt-9b@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1mWaZq-0002jt-9b@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-committers@postgresql.org
  Cc: michael@paquier.xyz
  Subject: Re: pgsql: pg_stat_statements: Add some tests for older versions still usab
  In-Reply-To: <E1mWaZq-0002jt-9b@gemulon.postgresql.org>
  References: <E1mWaZq-0002jt-9b@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox