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-0016il-Iv@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_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/1d0399b54068586db003691c218c3d68bee055c8 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 по дате отправления: