diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2013-10-26 11:24:04 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2013-10-26 11:24:04 -0400 |
| commit | 9c339eb4f853e44c462f53587f69e4a11e89c09b (patch) | |
| tree | dfd9e0203f6c144d7687edc8e17d405302a9ab54 /src/test/regress/sql/rules.sql | |
| parent | 9f9d9b51f068a19ad243fd8fe500c9970999db9b (diff) | |
| download | postgresql-9c339eb4f853e44c462f53587f69e4a11e89c09b.tar.gz | |
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
Diffstat (limited to 'src/test/regress/sql/rules.sql')
| -rw-r--r-- | src/test/regress/sql/rules.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/src/test/regress/sql/rules.sql b/src/test/regress/sql/rules.sql index 6361297155..1e15f84dc8 100644 --- a/src/test/regress/sql/rules.sql +++ b/src/test/regress/sql/rules.sql @@ -768,11 +768,18 @@ drop table cchild; -- -- Check that ruleutils are working -- + +-- temporarily disable fancy output, so view changes create less diff noise +\a\t + SELECT viewname, definition FROM pg_views WHERE schemaname <> 'information_schema' ORDER BY viewname; SELECT tablename, rulename, definition FROM pg_rules ORDER BY tablename, rulename; +-- restore normal output mode +\a\t + -- -- CREATE OR REPLACE RULE -- |