projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 9ec0b29) | patch
Expand virtual generated columns in constraint expressions
authorPeter Eisentraut <[email protected]>
Mon, 15 Sep 2025 14:27:50 +0000 (16:27 +0200)
committerPeter Eisentraut <[email protected]>
Mon, 15 Sep 2025 14:27:50 +0000 (16:27 +0200)
commitce71993ae46930ddb1ff790807114384898b86a7
tree1d8d390b8d3c948ae227f28aa44008239fe94f11tree
parent9ec0b29976b6d73cc08880842caa0db286e46bd4commit | 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 <[email protected]>
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
This is the main PostgreSQL git repository.