Horton

Expand virtual generated columns in constraint expressions

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: ce71993ae46930ddb1ff790807114384898b86a7
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2025-09-15T14:27:50Z
Releases: 19 (unreleased) 
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

Files

PathChange+/−
src/backend/optimizer/util/plancat.c modified +9 −0
src/test/regress/expected/generated_virtual.out modified +23 −0
src/test/regress/sql/generated_virtual.sql modified +15 −0

Discussion