public inbox for [email protected]help / color / mirror / Atom feed
pgsql: doc: Clarify COPY FROM WHERE expression restrictions 7+ messages / 1 participants [nested] [flat]
* pgsql: doc: Clarify COPY FROM WHERE expression restrictions @ 2026-07-08 03:46 Fujii Masao <[email protected]> 0 siblings, 0 replies; 7+ messages in thread From: Fujii Masao @ 2026-07-08 03:46 UTC (permalink / raw) To: [email protected] 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 <[email protected]> Reviewed-by: Ayush Tiwari <[email protected]> Discussion: https://postgr.es/m/CAHGQGwEgxErc54yVOAVWCsr1O=8pgw4oKRPuEQ9mfhkoYGR_XA@mail.gmail.com Backpatch-through: 14 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/d35e8babc4602c73ec4f66f93a5004a2ead62438 Modified Files -------------- doc/src/sgml/ref/copy.sgml | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: doc: Clarify COPY FROM WHERE expression restrictions @ 2026-07-08 03:46 Fujii Masao <[email protected]> 0 siblings, 0 replies; 7+ messages in thread From: Fujii Masao @ 2026-07-08 03:46 UTC (permalink / raw) To: [email protected] 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 <[email protected]> Reviewed-by: Ayush Tiwari <[email protected]> Discussion: https://postgr.es/m/CAHGQGwEgxErc54yVOAVWCsr1O=8pgw4oKRPuEQ9mfhkoYGR_XA@mail.gmail.com Backpatch-through: 14 Branch ------ REL_19_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/64ed30fda8d77782bd69297e3892895ca9f84816 Modified Files -------------- doc/src/sgml/ref/copy.sgml | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: doc: Clarify COPY FROM WHERE expression restrictions @ 2026-07-08 03:47 Fujii Masao <[email protected]> 0 siblings, 0 replies; 7+ messages in thread From: Fujii Masao @ 2026-07-08 03:47 UTC (permalink / raw) To: [email protected] 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 <[email protected]> Reviewed-by: Ayush Tiwari <[email protected]> Discussion: https://postgr.es/m/CAHGQGwEgxErc54yVOAVWCsr1O=8pgw4oKRPuEQ9mfhkoYGR_XA@mail.gmail.com Backpatch-through: 14 Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/abecdbc6af0192eb8fc017af5c7a3bb3d5da1ae3 Modified Files -------------- doc/src/sgml/ref/copy.sgml | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: doc: Clarify COPY FROM WHERE expression restrictions @ 2026-07-08 03:47 Fujii Masao <[email protected]> 0 siblings, 0 replies; 7+ messages in thread From: Fujii Masao @ 2026-07-08 03:47 UTC (permalink / raw) To: [email protected] 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 <[email protected]> Reviewed-by: Ayush Tiwari <[email protected]> Discussion: https://postgr.es/m/CAHGQGwEgxErc54yVOAVWCsr1O=8pgw4oKRPuEQ9mfhkoYGR_XA@mail.gmail.com Backpatch-through: 14 Branch ------ REL_17_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/4d0c3eba1dca2c40fbca734f069cdfc675c54a1b Modified Files -------------- doc/src/sgml/ref/copy.sgml | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: doc: Clarify COPY FROM WHERE expression restrictions @ 2026-07-08 03:47 Fujii Masao <[email protected]> 0 siblings, 0 replies; 7+ messages in thread From: Fujii Masao @ 2026-07-08 03:47 UTC (permalink / raw) To: [email protected] 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 <[email protected]> Reviewed-by: Ayush Tiwari <[email protected]> Discussion: https://postgr.es/m/CAHGQGwEgxErc54yVOAVWCsr1O=8pgw4oKRPuEQ9mfhkoYGR_XA@mail.gmail.com Backpatch-through: 14 Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/497d2ebbfb9a79f493ed43b1fe98853b05b45d63 Modified Files -------------- doc/src/sgml/ref/copy.sgml | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: doc: Clarify COPY FROM WHERE expression restrictions @ 2026-07-08 03:47 Fujii Masao <[email protected]> 0 siblings, 0 replies; 7+ messages in thread From: Fujii Masao @ 2026-07-08 03:47 UTC (permalink / raw) To: [email protected] 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 <[email protected]> Reviewed-by: Ayush Tiwari <[email protected]> Discussion: https://postgr.es/m/CAHGQGwEgxErc54yVOAVWCsr1O=8pgw4oKRPuEQ9mfhkoYGR_XA@mail.gmail.com Backpatch-through: 14 Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/8691659595b5d33eec0b7a539edd42ab827fda49 Modified Files -------------- doc/src/sgml/ref/copy.sgml | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: doc: Clarify COPY FROM WHERE expression restrictions @ 2026-07-08 03:47 Fujii Masao <[email protected]> 0 siblings, 0 replies; 7+ messages in thread From: Fujii Masao @ 2026-07-08 03:47 UTC (permalink / raw) To: [email protected] 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 <[email protected]> Reviewed-by: Ayush Tiwari <[email protected]> Discussion: https://postgr.es/m/CAHGQGwEgxErc54yVOAVWCsr1O=8pgw4oKRPuEQ9mfhkoYGR_XA@mail.gmail.com Backpatch-through: 14 Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/fd224fe90823de3df4f209c09a5794606ff70dc7 Modified Files -------------- doc/src/sgml/ref/copy.sgml | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) ^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2026-07-08 03:47 UTC | newest] Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-07-08 03:46 pgsql: doc: Clarify COPY FROM WHERE expression restrictions Fujii Masao <[email protected]> 2026-07-08 03:46 pgsql: doc: Clarify COPY FROM WHERE expression restrictions Fujii Masao <[email protected]> 2026-07-08 03:47 pgsql: doc: Clarify COPY FROM WHERE expression restrictions Fujii Masao <[email protected]> 2026-07-08 03:47 pgsql: doc: Clarify COPY FROM WHERE expression restrictions Fujii Masao <[email protected]> 2026-07-08 03:47 pgsql: doc: Clarify COPY FROM WHERE expression restrictions Fujii Masao <[email protected]> 2026-07-08 03:47 pgsql: doc: Clarify COPY FROM WHERE expression restrictions Fujii Masao <[email protected]> 2026-07-08 03:47 pgsql: doc: Clarify COPY FROM WHERE expression restrictions Fujii Masao <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox