*** /Users/mark/master/postgresql/src/test/regress/expected/oidjoins.out 2017-11-10 06:50:30.000000000 -0800 --- /Users/mark/master/postgresql/src/test/regress/results/oidjoins.out 2017-12-19 11:31:42.000000000 -0800 *************** *** 621,629 **** FROM pg_catalog.pg_opclass fk WHERE opcfamily != 0 AND NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.opcfamily); ! ctid | opcfamily ! ------+----------- ! (0 rows) SELECT ctid, opcintype FROM pg_catalog.pg_opclass fk --- 621,630 ---- FROM pg_catalog.pg_opclass fk WHERE opcfamily != 0 AND NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.opcfamily); ! ctid | opcfamily ! --------+----------- ! (1,57) | 5028 ! (1 row) SELECT ctid, opcintype FROM pg_catalog.pg_opclass fk ====================================================================== *** /Users/mark/master/postgresql/src/test/regress/expected/opr_sanity.out 2017-12-19 11:28:04.000000000 -0800 --- /Users/mark/master/postgresql/src/test/regress/results/opr_sanity.out 2017-12-19 11:31:44.000000000 -0800 *************** *** 1700,1709 **** -- Ask access methods to validate opclasses -- (this replaces a lot of SQL-level checks that used to be done in this file) SELECT oid, opcname FROM pg_opclass WHERE NOT amvalidate(oid); ! oid | opcname ! -----+--------- ! (0 rows) ! -- **************** pg_am **************** -- Look for illegal values in pg_am fields SELECT p1.oid, p1.amname --- 1700,1706 ---- -- Ask access methods to validate opclasses -- (this replaces a lot of SQL-level checks that used to be done in this file) SELECT oid, opcname FROM pg_opclass WHERE NOT amvalidate(oid); ! ERROR: cache lookup failed for operator family 5028 -- **************** pg_am **************** -- Look for illegal values in pg_am fields SELECT p1.oid, p1.amname *************** *** 1901,1909 **** WHERE NOT EXISTS(SELECT 1 FROM pg_amop AS p2 WHERE p2.amopfamily = p1.opcfamily AND binary_coercible(p1.opcintype, p2.amoplefttype)); ! opcname | opcfamily ! ---------+----------- ! (0 rows) -- Check that each operator listed in pg_amop has an associated opclass, -- that is one whose opcintype matches oprleft (possibly by coercion). --- 1898,1907 ---- WHERE NOT EXISTS(SELECT 1 FROM pg_amop AS p2 WHERE p2.amopfamily = p1.opcfamily AND binary_coercible(p1.opcintype, p2.amoplefttype)); ! opcname | opcfamily ! ---------------+----------- ! oid_bloom_ops | 5028 ! (1 row) -- Check that each operator listed in pg_amop has an associated opclass, -- that is one whose opcintype matches oprleft (possibly by coercion). *************** *** 1918,1924 **** AND binary_coercible(p2.opcintype, p1.amoplefttype)); amopfamily | amopstrategy | amopopr ------------+--------------+--------- ! (0 rows) -- Operators that are primary members of opclasses must be immutable (else -- it suggests that the index ordering isn't fixed). Operators that are --- 1916,1923 ---- AND binary_coercible(p2.opcintype, p1.amoplefttype)); amopfamily | amopstrategy | amopopr ------------+--------------+--------- ! 5029 | 1 | 607 ! (1 row) -- Operators that are primary members of opclasses must be immutable (else -- it suggests that the index ordering isn't fixed). Operators that are ======================================================================