pgsql: Fix infer_arbiter_indexes() to not assume resultRelation is 1.
От | Tom Lane |
---|---|
Тема | pgsql: Fix infer_arbiter_indexes() to not assume resultRelation is 1. |
Дата | |
Msg-id | E1sH9VO-0016ii-IE@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Fix infer_arbiter_indexes() to not assume resultRelation is 1. infer_arbiter_indexes failed to renumber varnos in index expressions or predicates that it got from the catalogs. This escaped detection up to now because the stored varnos in such trees will be 1, and an INSERT's result relation is usually the first rangetable entry, so that that was fine. However, in cases such as inserting through an updatable view, it's not fine, leading to failure to match the expressions to the query with ensuing "there is no unique or exclusion constraint matching the ON CONFLICT specification" errors. Fix by copy-and-paste from get_relation_info(). Per bug #18502 from Michael Wang. Back-patch to all supported versions. Discussion: https://postgr.es/m/18502-545b53f5b81e54e0@postgresql.org Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b188e1bf75760fed76406a48c81bcd8ac6a8fda9 Modified Files -------------- src/backend/optimizer/util/plancat.c | 9 ++++++++- src/test/regress/expected/insert_conflict.out | 13 +++++++++++++ src/test/regress/sql/insert_conflict.sql | 6 ++++++ 3 files changed, 27 insertions(+), 1 deletion(-)
В списке pgsql-committers по дате отправления: