diff options
Diffstat (limited to 'contrib/findoidjoins/README.findoidjoins')
| -rw-r--r-- | contrib/findoidjoins/README.findoidjoins | 16 |
1 files changed, 9 insertions, 7 deletions
diff --git a/contrib/findoidjoins/README.findoidjoins b/contrib/findoidjoins/README.findoidjoins index 288c3f8e98d..712fc1373e4 100644 --- a/contrib/findoidjoins/README.findoidjoins +++ b/contrib/findoidjoins/README.findoidjoins @@ -9,10 +9,10 @@ it on anything but an empty database, such as template1. Uses pgeasy library. Run on an empty database, it returns the system join relationships (shown -below for 7.1). Note that unexpected matches may indicate bogus entries +below for 7.2). Note that unexpected matches may indicate bogus entries in system tables --- don't accept a peculiar match without question. In particular, a field shown as joining to more than one target table is -probably messed up. In 7.1, the *only* field that should join to more +probably messed up. In 7.2, the *only* field that should join to more than one target is pg_description.objoid. (Running make_oidjoins_check is an easy way to spot fields joining to more than one table, BTW.) @@ -27,9 +27,8 @@ revision in the patterns of cross-links between system tables. (Ideally we'd just regenerate the script as part of the regression tests themselves, but that seems too slow...) -NOTE: in 7.1, make_oidjoins_check produces two bogus join checks, one for -pg_database.datlastsysoid => pg_description.oid and one for -pg_class.relfilenode => pg_class.oid. These are artifacts and should not +NOTE: in 7.2, make_oidjoins_check produces one bogus join check, for +pg_class.relfilenode => pg_class.oid. This is an artifact and should not be added to the oidjoins regress test. --------------------------------------------------------------------------- @@ -41,13 +40,13 @@ Join pg_aggregate.aggtranstype => pg_type.oid Join pg_aggregate.aggfinaltype => pg_type.oid Join pg_am.amgettuple => pg_proc.oid Join pg_am.aminsert => pg_proc.oid -Join pg_am.amdelete => pg_proc.oid Join pg_am.ambeginscan => pg_proc.oid Join pg_am.amrescan => pg_proc.oid Join pg_am.amendscan => pg_proc.oid Join pg_am.ammarkpos => pg_proc.oid Join pg_am.amrestrpos => pg_proc.oid Join pg_am.ambuild => pg_proc.oid +Join pg_am.ambulkdelete => pg_proc.oid Join pg_am.amcostestimate => pg_proc.oid Join pg_amop.amopid => pg_am.oid Join pg_amop.amopclaid => pg_opclass.oid @@ -61,6 +60,7 @@ Join pg_class.reltype => pg_type.oid Join pg_class.relam => pg_am.oid Join pg_class.reltoastrelid => pg_class.oid Join pg_class.reltoastidxid => pg_class.oid +Join pg_description.classoid => pg_class.oid Join pg_index.indexrelid => pg_class.oid Join pg_index.indrelid => pg_class.oid Join pg_opclass.opcdeftype => pg_type.oid @@ -78,7 +78,9 @@ Join pg_proc.prolang => pg_language.oid Join pg_proc.prorettype => pg_type.oid Join pg_rewrite.ev_class => pg_class.oid Join pg_statistic.starelid => pg_class.oid -Join pg_statistic.staop => pg_operator.oid +Join pg_statistic.staop1 => pg_operator.oid +Join pg_statistic.staop2 => pg_operator.oid +Join pg_statistic.staop3 => pg_operator.oid Join pg_trigger.tgrelid => pg_class.oid Join pg_trigger.tgfoid => pg_proc.oid Join pg_type.typrelid => pg_class.oid |