pgsql: Add convenience view to stats import test. - Mailing list pgsql-committers

From Nathan Bossart
Subject pgsql: Add convenience view to stats import test.
Date
Msg-id E1w18ks-00019j-0p@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Add convenience view to stats import test.

Presently, many statements in stats_import.sql select all columns
from the pg_stats system view.  A proposed follow-up commit would
add columns to this view (some of which are not stable across test
runs), breaking all of these tests.  This commit introduces a
convenience view for those statements so that future changes are
minimally disruptive.

Author: Corey Huinker <corey.huinker@gmail.com>
Reviewed-by: Sami Imseih <samimseih@gmail.com>
Discussion: https://postgr.es/m/CADkLM%3DcoCVy92QkVUUTLdo5eO2bMDtwMrzRn_8miAhX%2BuPaqXg%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/233bbdf031e4832a409e3028b45d709e7ddb93c9

Modified Files
--------------
src/test/regress/expected/stats_import.out | 65 ++++++++++++++++++------------
src/test/regress/sql/stats_import.sql      | 61 +++++++++++++++++-----------
2 files changed, 76 insertions(+), 50 deletions(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: Fix bug due to confusion about what IsMVCCSnapshot means
Next
From: Jeff Davis
Date:
Subject: Re: pgsql: CREATE SUBSCRIPTION ... SERVER.