Add opr_sanity queries to inspect commutator/negator links more closely

Enterprise / PostgreSQL - Tom Lane [sss.pgh.pa.us] - 16 August 2014 12:22 UTC

Make lists of the names of all operators that are claimed to be commutator pairs or negator pairs. This is analogous to the existing queries that make lists of all operator names appearing in particular opclass strategy slots. Unexpected additions to these lists are likely to be mistakes; had we had these queries in place before, bug #11178 might've been prevented.

a068b5b Add opr_sanity queries to inspect commutator/negator links more closely.
src/test/regress/expected/opr_sanity.out | 73 ++++++++++++++++++++++++++++--
src/test/regress/sql/opr_sanity.sql | 23 ++++++++--
2 files changed, 90 insertions(+), 6 deletions(-)

Upstream: git.postgresql.org

  • Share