pgsql: Disallow generated columns in COPY WHERE clause

Started by Peter Eisentraut8 months ago1 messagescomitters

peter_e@gmx.net

8 months ago

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: /messages/by-id/CACJufxHb8YPQ095R_pYDr77W9XKNaXg5Rzy-WP525mkq+hRM3g@mail.gmail.com

Branch
------
REL_17_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/07f787e57399ad6108c181b020723db24fa1dbe0

Modified Files
--------------
src/backend/commands/copy.c | 37 +++++++++++++++++++++++++++++++++
src/test/regress/expected/generated.out | 6 ++++++
src/test/regress/sql/generated.sql | 4 ++++
3 files changed, 47 insertions(+)