Improve index AMs' opclass validation procedures.
The amvalidate functions added in commit 65c5fcd353a859da were on the
crude side. Improve them in a few ways:
* Perform signature checking for operators and support functions.
* Apply more thorough checks for missing operators and functions,
where possible.
* Instead of reporting problems as ERRORs, report most problems as INFO
messages and make the amvalidate function return FALSE. This allows
more than one problem to be discovered per run.
* Report object names rather than OIDs, and work a bit harder on making
the messages understandable.
Also, remove a few more opr_sanity regression test queries that are
now superseded by the amvalidate checks.
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/be44ed27b86ebd165bbedf06a4ac5a8eb943d43c
Modified Files
--------------
src/backend/access/brin/brin_validate.c | 260 ++++++++++++++++++++-------
src/backend/access/gin/ginvalidate.c | 233 ++++++++++++++++++------
src/backend/access/gist/gistvalidate.c | 241 +++++++++++++++++++------
src/backend/access/hash/hashvalidate.c | 289 +++++++++++++++++++++++-------
src/backend/access/index/Makefile | 2 +-
src/backend/access/index/amvalidate.c | 246 +++++++++++++++++++++++++
src/backend/access/nbtree/nbtvalidate.c | 274 ++++++++++++++++------------
src/backend/access/spgist/spgvalidate.c | 211 +++++++++++++++++-----
src/backend/utils/cache/lsyscache.c | 23 +++
src/include/access/amvalidate.h | 36 ++++
src/include/utils/lsyscache.h | 1 +
src/test/regress/expected/opr_sanity.out | 204 +--------------------
src/test/regress/sql/opr_sanity.sql | 171 +-----------------
13 files changed, 1417 insertions(+), 774 deletions(-)