pgsql: Tweak regression test of pg_walinspect to be less collation-sens

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Tweak regression test of pg_walinspect to be less collation-sens
Date: 2023-03-16 04:32:09
Message-ID: E1pcfHd-003lhC-Fa@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Tweak regression test of pg_walinspect to be less collation-sensitive

\dx was used on pg_walinspect to list its objects in 1.0 but the names
of the objects in this version do not have an order that is always
guaranteed depending on the collation used. Rather than append a
COLLATE clause in the query of \dx, this tweaks the regression test to
produce an output whose order is guaranteed.

Reported-by: Andres Freund
Author: Bharath Rupireddy
Discussion: https://postgr.es/m/20230314215440.gma7g4keswdnldj5@awork3.anarazel.de

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/e643a315fc58deae20877e2e69358c95087fa09a

Modified Files
--------------
contrib/pg_walinspect/expected/oldextversions.out | 12 ++++++++----
contrib/pg_walinspect/sql/oldextversions.sql | 9 +++++++--
2 files changed, 15 insertions(+), 6 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2023-03-16 05:23:19 pgsql: Remove PgStat_BackendFunctionEntry
Previous Message Michael Paquier 2023-03-16 00:36:52 pgsql: Add .gitignore to ldap_password_func