]> 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:03 +0000 (14:02 +0100)
commit8278737bfd0a37b68121a42a0b0a6775488adb48
tree9772a32aae2530559127a2b853574c95b8c1c32b
parent1cba25e4cf2ea0d8efd1d3c8d0af3f7a3c091dfe
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