pgsql: Improve findoidjoins to cover more cases. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Improve findoidjoins to cover more cases.
Date
Msg-id E1QDmKU-000835-26@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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(-)


pgsql-committers by date:

Previous
From: Andrew Dunstan
Date:
Subject: pgsql: Silence a few compiler warnings from gcc on MinGW.
Next
From: Bruce Momjian
Date:
Subject: pgsql: In pg_upgrade, only compile copy_file() on non-Win32 systems.