Thread: pgsql: Improve findoidjoins to cover more cases.

pgsql: Improve findoidjoins to cover more cases.

From
Tom Lane
Date:
Improve findoidjoins to cover more cases.

Teach the program and script to deal with OID-array referencing columns,
which we now have several of.  Also, modify the recommended usage process
to specify that the program should be run against the regression database
rather than template1.  This lets it find numerous joins that cannot be
found in template1 because the relevant catalogs are entirely empty.

Together these changes add seventeen formerly-missed cases to the oidjoins
regression test.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/795c382e8caf27f9db2fb09d12384b8183280fee

Modified Files
--------------
src/test/regress/expected/oidjoins.out     |  136 ++++++++++++++++++++++++++++
src/test/regress/sql/oidjoins.sql          |   68 ++++++++++++++
src/tools/findoidjoins/README              |   57 ++++++++----
src/tools/findoidjoins/findoidjoins.c      |   95 +++++++++++++++++---
src/tools/findoidjoins/make_oidjoins_check |   22 ++++--
5 files changed, 342 insertions(+), 36 deletions(-)