projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 1cba25e) | patch
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
tree9772a32aae2530559127a2b853574c95b8c1c32btree
parent1cba25e4cf2ea0d8efd1d3c8d0af3f7a3c091dfecommit | diff
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 diff | blob | blame | history
src/test/regress/expected/generated.out diff | blob | blame | history
src/test/regress/sql/generated.sql diff | blob | blame | history
This is the main PostgreSQL git repository.