| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Fix match_foreign_keys_to_quals for FKs linking to unused rtable |
| Date: | 2016-06-29 20:02:28 |
| Message-ID: | E1bILgq-0001Oj-0H@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)1397(dot)43514(at)wrigleys(dot)postgresql(dot)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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2016-06-29 20:58:02 | pgsql: Add conninfo to pg_stat_wal_receiver |
| Previous Message | Tom Lane | 2016-06-29 19:00:40 | pgsql: Adjust text search documentation for recent commits. |