]> granicus.if.org Git - postgresql/commit
Suppress less info in regression tests using DROP CASCADE.
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 1 Aug 2017 20:49:23 +0000 (16:49 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 1 Aug 2017 20:49:23 +0000 (16:49 -0400)
commit8e7537261c4b7d296fc10513b93bd67dc3d415b0
tree36349bcce6b8a8012af3684564d84df97ef49b74
parent1e165d05fe06a9072867607886f818bc255507db
Suppress less info in regression tests using DROP CASCADE.

DROP CASCADE doesn't currently promise to visit dependent objects in
a fixed order, so when the regression tests use it, we typically need
to suppress the details of which objects get dropped in order to have
predictable test output.  Traditionally we've done that by setting
client_min_messages higher than NOTICE, but there's a better way:
we can "\set VERBOSITY terse" in psql.  That suppresses the DETAIL
message with the object list, but we still get the basic notice telling
how many objects were dropped.  So at least the test case can verify
that the expected number of objects were dropped.

The VERBOSITY method was already in use in a few places, but run
around and use it wherever it makes sense.

Discussion: https://postgr.es/m/10766.1501608885@sss.pgh.pa.us
18 files changed:
src/test/regress/expected/alter_generic.out
src/test/regress/expected/create_index.out
src/test/regress/expected/create_view.out
src/test/regress/expected/object_address.out
src/test/regress/expected/privileges.out
src/test/regress/expected/rowsecurity.out
src/test/regress/expected/rules.out
src/test/regress/expected/stats_ext.out
src/test/regress/expected/typed_table.out
src/test/regress/sql/alter_generic.sql
src/test/regress/sql/create_index.sql
src/test/regress/sql/create_view.sql
src/test/regress/sql/object_address.sql
src/test/regress/sql/privileges.sql
src/test/regress/sql/rowsecurity.sql
src/test/regress/sql/rules.sql
src/test/regress/sql/stats_ext.sql
src/test/regress/sql/typed_table.sql