pgsql: Fix match_foreign_keys_to_quals for FKs linking to unused rtable - Mailing list pgsql-committers

Fix match_foreign_keys_to_quals for FKs linking to unused rtable entries.

Since get_relation_foreign_keys doesn't try to determine whether RTEs
are actually part of the query semantics, it might make FK info records
linking to RTEs that won't have a RelOptInfo at all.  Cope with that.
Per bug #14219 from Andrew Gierth.

Report: <20160629183338.1397.43514@wrigleys.postgresql.org>

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/b32e63506cfec8c8bd3237ec5043de7414564d10

Modified Files
--------------
src/backend/optimizer/plan/initsplan.c    | 19 +++++++++++++++++--
src/test/regress/expected/foreign_key.out | 22 ++++++++++++++++++++++
src/test/regress/sql/foreign_key.sql      | 10 ++++++++++
3 files changed, 49 insertions(+), 2 deletions(-)