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_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/8278737bfd0a37b68121a42a0b0a6775488adb48

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(+)