pgsql: Fix match_foreign_keys_to_quals for FKs linking to unused rtable

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Fix match_foreign_keys_to_quals for FKs linking to unused rtable
Дата
Msg-id E1bILgq-0001Oj-0H@gemulon.postgresql.org
обсуждение исходный текст
Список 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(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Adjust text search documentation for recent commits.
Следующее
От: Alvaro Herrera
Дата:
Сообщение: pgsql: Add conninfo to pg_stat_wal_receiver