@@ -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 8.0 ). Note that unexpected matches may indicate bogus entries
10+ below for 8.1 ). 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 8.0 , the *only* fields that should join to more
13+ probably messed up. In 8.1 , 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,22 +26,22 @@ 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 8.0 , make_oidjoins_check producesone bogus joincheck :
29+ NOTE: in 8.1 , make_oidjoins_check producestwo bogus joinchecks :
3030Join pg_catalog.pg_class.relfilenode => pg_catalog.pg_class.oid
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 8.0, but it did happen before and might
34- happen again in future, depending on what operation initdb does last.
31+ Join pg_catalog.pg_database.datlastsysoid => pg_catalog.pg_database.oid
32+ These are artifacts and should not be added to the oidjoins regress test.
3533
3634---------------------------------------------------------------------------
3735
3836Join pg_catalog.pg_aggregate.aggfnoid => pg_catalog.pg_proc.oid
3937Join pg_catalog.pg_aggregate.aggtransfn => pg_catalog.pg_proc.oid
4038Join pg_catalog.pg_aggregate.aggfinalfn => pg_catalog.pg_proc.oid
39+ Join pg_catalog.pg_aggregate.aggsortop => pg_catalog.pg_operator.oid
4140Join pg_catalog.pg_aggregate.aggtranstype => pg_catalog.pg_type.oid
42- Join pg_catalog.pg_am.amgettuple => pg_catalog.pg_proc.oid
4341Join pg_catalog.pg_am.aminsert => pg_catalog.pg_proc.oid
4442Join pg_catalog.pg_am.ambeginscan => pg_catalog.pg_proc.oid
43+ Join pg_catalog.pg_am.amgettuple => pg_catalog.pg_proc.oid
44+ Join pg_catalog.pg_am.amgetmulti => pg_catalog.pg_proc.oid
4545Join pg_catalog.pg_am.amrescan => pg_catalog.pg_proc.oid
4646Join pg_catalog.pg_am.amendscan => pg_catalog.pg_proc.oid
4747Join pg_catalog.pg_am.ammarkpos => pg_catalog.pg_proc.oid