pgsql: Use unaligned output in selected regression queries to reduce di - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Use unaligned output in selected regression queries to reduce di
Date
Msg-id E1Va5ji-0008Op-Dp@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Use unaligned output in selected regression queries to reduce diff noise.

The rules regression test prints all known views and rules, which is a set
that changes regularly.  Previously, a change in one rule would frequently
lead to whitespace changes across the entire output of this query, which is
painful to verify and causes undesirable conflicts between unrelated patch
sets.  Use \a mode to improve matters.  Also use \t mode to suppress the
total-rows count, which was also a source of unnecessary patch conflicts.

Likewise modify the output mode for the list of indexed tables generated
in sanity_check.sql.  There might be other places where we should use this
idea, but these are the ones that have caused the most problems.

Andres Freund

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/9c339eb4f853e44c462f53587f69e4a11e89c09b

Modified Files
--------------
src/test/regress/expected/rules.out        | 1936 ++++++++++++++--------------
src/test/regress/expected/sanity_check.out |  320 ++---
src/test/regress/sql/rules.sql             |    7 +
src/test/regress/sql/sanity_check.sql      |    7 +
4 files changed, 1140 insertions(+), 1130 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Improve pqexpbuffer.c to use modern vsnprintf implementations ef
Next
From: Noah Misch
Date:
Subject: pgsql: Add large object functions catering to SQL callers.