]> git.ipfire.org Git - thirdparty/postgresql.git/commit
projects / thirdparty / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 3888391) | patch
Expand virtual generated columns in constraint expressions
authorPeter Eisentraut <peter@eisentraut.org>
Mon, 15 Sep 2025 14:27:50 +0000 (16:27 +0200)
committerPeter Eisentraut <peter@eisentraut.org>
Mon, 15 Sep 2025 14:28:45 +0000 (16:28 +0200)
commite7a2bbdb522dd6fc7283550742b8b52605198783
tree605b8a5ee808d5a05c9ffd52ad3e2146b4cb3bactree | snapshot
parent38883916e41c5d3f3367b221b37838c3999227e2commit | diff
Expand virtual generated columns in constraint expressions

Virtual generated columns in constraint expressions need to be
expanded because the optimizer matches these expressions to qual
clauses.  Failing to do so can cause us to miss opportunities for
constraint exclusion.

Author: Richard Guo <guofenglinux@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/204804c0-798f-4c72-bd1f-36116024fda3%40eisentraut.org
src/backend/optimizer/util/plancat.c diff | blob | blame | history
src/test/regress/expected/generated_virtual.out diff | blob | blame | history
src/test/regress/sql/generated_virtual.sql diff | blob | blame | history
Mirror of https://git.postgresql.org/git/postgresql.git