@@ -7,10 +7,10 @@ anything but an empty database, such as template1; else it's likely to
77be very slow.
88
99Run on an empty database, it returns the system join relationships (shown
10- below for 7.3 ). Note that unexpected matches may indicate bogus entries
10+ below for 7.4 ). Note that unexpected matches may indicate bogus entries
1111in system tables --- don't accept a peculiar match without question.
1212In particular, a field shown as joining to more than one target table is
13- probably messed up. In 7.3 , the *only* fields that should join to more
13+ probably messed up. In 7.4 , the *only* fields that should join to more
1414than one target are pg_description.objoid, pg_depend.objid, and
1515pg_depend.refobjid. (Running make_oidjoins_check is an easy way to spot
1616fields joining to more than one table, BTW.)
@@ -26,10 +26,12 @@ revision in the patterns of cross-links between system tables.
2626(Ideally we'd just regenerate the script as part of the regression
2727tests themselves, but that seems too slow...)
2828
29- NOTE: in 7.3 , make_oidjoins_check producestwo bogus joinchecks :
29+ NOTE: in 7.4 , make_oidjoins_check producesone bogus joincheck :
3030Join pg_catalog.pg_class.relfilenode => pg_catalog.pg_class.oid
31- Join pg_catalog.pg_database.datlastsysoid => pg_catalog.pg_conversion.oid
32- These are artifacts and should not be added to the oidjoins regress test.
31+ This is an artifact and should not be added to the oidjoins regress test.
32+ Also beware of any claim that pg_database.datlastsysoid joins to anything;
33+ this does not actually happen in 7.4, but it did happen before and might
34+ happen again in future, depending on what operation initdb does last.
3335
3436---------------------------------------------------------------------------
3537
@@ -46,6 +48,7 @@ Join pg_catalog.pg_am.ammarkpos => pg_catalog.pg_proc.oid
4648Join pg_catalog.pg_am.amrestrpos => pg_catalog.pg_proc.oid
4749Join pg_catalog.pg_am.ambuild => pg_catalog.pg_proc.oid
4850Join pg_catalog.pg_am.ambulkdelete => pg_catalog.pg_proc.oid
51+ Join pg_catalog.pg_am.amvacuumcleanup => pg_catalog.pg_proc.oid
4952Join pg_catalog.pg_am.amcostestimate => pg_catalog.pg_proc.oid
5053Join pg_catalog.pg_amop.amopclaid => pg_catalog.pg_opclass.oid
5154Join pg_catalog.pg_amop.amopopr => pg_catalog.pg_operator.oid
@@ -61,6 +64,8 @@ Join pg_catalog.pg_class.reltype => pg_catalog.pg_type.oid
6164Join pg_catalog.pg_class.relam => pg_catalog.pg_am.oid
6265Join pg_catalog.pg_class.reltoastrelid => pg_catalog.pg_class.oid
6366Join pg_catalog.pg_class.reltoastidxid => pg_catalog.pg_class.oid
67+ Join pg_catalog.pg_constraint.connamespace => pg_catalog.pg_namespace.oid
68+ Join pg_catalog.pg_constraint.contypid => pg_catalog.pg_type.oid
6469Join pg_catalog.pg_conversion.connamespace => pg_catalog.pg_namespace.oid
6570Join pg_catalog.pg_conversion.conproc => pg_catalog.pg_proc.oid
6671Join pg_catalog.pg_depend.classid => pg_catalog.pg_class.oid
@@ -100,6 +105,9 @@ Join pg_catalog.pg_type.typrelid => pg_catalog.pg_class.oid
100105Join pg_catalog.pg_type.typelem => pg_catalog.pg_type.oid
101106Join pg_catalog.pg_type.typinput => pg_catalog.pg_proc.oid
102107Join pg_catalog.pg_type.typoutput => pg_catalog.pg_proc.oid
108+ Join pg_catalog.pg_type.typreceive => pg_catalog.pg_proc.oid
109+ Join pg_catalog.pg_type.typsend => pg_catalog.pg_proc.oid
110+ Join pg_catalog.pg_type.typbasetype => pg_catalog.pg_type.oid
103111
104112---------------------------------------------------------------------------
105113