diff options
Diffstat (limited to 'contrib/findoidjoins/README')
| -rw-r--r-- | contrib/findoidjoins/README | 13 |
1 files changed, 8 insertions, 5 deletions
diff --git a/contrib/findoidjoins/README b/contrib/findoidjoins/README index c67d341339d..44c150a43f9 100644 --- a/contrib/findoidjoins/README +++ b/contrib/findoidjoins/README @@ -4,15 +4,15 @@ This program scans a database, and prints oid fields (also regproc fields) and the tables they join to. CAUTION: it is ver-r-r-y slow on a large database, or even a not-so-large one. We don't really recommend running -it on anything but an empty database. +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 6.5). Note that unexpected matches may indicate bogus entries +below for 7.0). 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 6.5, the *only* field that should join to more +probably messed up. In 7.0, 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.) @@ -45,11 +45,10 @@ 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.amcostestimate => pg_proc.oid Join pg_amop.amopid => pg_am.oid Join pg_amop.amopclaid => pg_opclass.oid Join pg_amop.amopopr => pg_operator.oid -Join pg_amop.amopselect => pg_proc.oid -Join pg_amop.amopnpages => pg_proc.oid Join pg_amproc.amid => pg_am.oid Join pg_amproc.amopclaid => pg_opclass.oid Join pg_amproc.amproc => pg_proc.oid @@ -75,6 +74,10 @@ Join pg_operator.oprjoin => pg_proc.oid 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_trigger.tgrelid => pg_class.oid +Join pg_trigger.tgfoid => pg_proc.oid Join pg_type.typrelid => pg_class.oid Join pg_type.typelem => pg_type.oid Join pg_type.typinput => pg_proc.oid |