]> git.ipfire.org Git - thirdparty/postgresql.git/commit
doc: Clarify COPY FROM WHERE expression restrictions
authorFujii Masao <fujii@postgresql.org>
Wed, 8 Jul 2026 03:45:20 +0000 (12:45 +0900)
committerFujii Masao <fujii@postgresql.org>
Wed, 8 Jul 2026 03:45:57 +0000 (12:45 +0900)
commit4d0c3eba1dca2c40fbca734f069cdfc675c54a1b
tree062ed2337cc85e5e1fa57f373de2f7cad60dd15e
parent3017543b1ca97089b2db96275af65d351188eed6
doc: Clarify COPY FROM WHERE expression restrictions

Commit aa606b9316a disallowed generated columns in COPY FROM WHERE
expressions, and commit 21c69dc73f9 disallowed system columns.
However, the COPY reference page still mentions only the restriction
on subqueries.

Update the documentation to also list generated columns and system
columns as unsupported in COPY FROM WHERE expressions.

Backpatch the generated-column documentation change to all supported
versions. Backpatch the system-column documentation change to v19,
where that restriction was introduced.

Author: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Ayush Tiwari <ayushtiwari.slg01@gmail.com>
Discussion: https://postgr.es/m/CAHGQGwEgxErc54yVOAVWCsr1O=8pgw4oKRPuEQ9mfhkoYGR_XA@mail.gmail.com
Backpatch-through: 14
doc/src/sgml/ref/copy.sgml