Clean up bogosities in pg_opclass, pg_amop, pg_amproc. There are amproc
Tom Lane <tgl@sss.pgh.pa.us>
Clean up bogosities in pg_opclass, pg_amop, pg_amproc. There are amproc entries now for int8 and network hash indexes. int24_ops and int42_ops are gone. pg_opclass no longer contains multiple entries claiming to be the default opclass for the same datatype. opr_sanity regress test extended to catch errors like these in the future.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/indices.sgml | modified | +0 −11 |
| doc/src/sgml/ref/create_index.sgml | modified | +1 −12 |
| src/backend/access/hash/hashfunc.c | modified | +41 −126 |
| src/backend/access/nbtree/nbtcompare.c | modified | +1 −29 |
| src/backend/utils/adt/date.c | modified | +25 −5 |
| src/backend/utils/adt/timestamp.c | modified | +18 −1 |
| src/backend/utils/adt/varchar.c | modified | +11 −85 |
| src/backend/utils/cache/catcache.c | modified | +2 −2 |
| src/include/access/hash.h | modified | +5 −4 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_amop.h | modified | +19 −33 |
| src/include/catalog/pg_amproc.h | modified | +14 −12 |
| src/include/catalog/pg_opclass.h | modified | +4 −8 |
| src/include/catalog/pg_proc.h | modified | +10 −10 |
| src/include/utils/builtins.h | modified | +3 −6 |
| src/include/utils/date.h | modified | +2 −1 |
| src/include/utils/timestamp.h | modified | +2 −1 |
| src/test/regress/expected/opr_sanity.out | modified | +56 −3 |
| src/test/regress/sql/opr_sanity.sql | modified | +53 −3 |