]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Disallow generated columns in COPY WHERE clause
authorPeter Eisentraut <peter@eisentraut.org>
Thu, 6 Nov 2025 10:52:47 +0000 (11:52 +0100)
committerPeter Eisentraut <peter@eisentraut.org>
Thu, 6 Nov 2025 13:02:09 +0000 (14:02 +0100)
commitccfe28eb42370c1ce7b62c03fc4f2081ab6ba25d
treed633bc5b1a8ec1405835ce1f14cfcce358f0c4c6
parentb8b37f0ee2a38154199bdc3b61df89ac9b8ae1e8
Disallow generated columns in COPY WHERE clause

Stored generated columns are not yet computed when the filtering
happens, so we need to prohibit them to avoid incorrect behavior.

Co-authored-by: jian he <jian.universality@gmail.com>
Reviewed-by: Kirill Reshke <reshkekirill@gmail.com>
Reviewed-by: Masahiko Sawada <sawada.mshk@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/CACJufxHb8YPQ095R_pYDr77W9XKNaXg5Rzy-WP525mkq+hRM3g@mail.gmail.com
src/backend/commands/copy.c
src/test/regress/expected/generated.out
src/test/regress/sql/generated.sql