diff options
| author | Nathan Bossart <nathan@postgresql.org> | 2025-02-06 15:23:40 -0600 |
|---|---|---|
| committer | Nathan Bossart <nathan@postgresql.org> | 2025-02-06 15:23:40 -0600 |
| commit | 401a6956fa69c9202cbc14c09ba8a9c430b90cac (patch) | |
| tree | fafb71e2d66bf494abee2f15a85fb36161b91bb6 /doc/src | |
| parent | a99a32e43ed72bd4fdb0950d2359fa4aa50fab76 (diff) | |
| download | postgresql-401a6956fa69c9202cbc14c09ba8a9c430b90cac.tar.gz postgresql-401a6956fa69c9202cbc14c09ba8a9c430b90cac.zip | |
Disallow COPY FREEZE on foreign tables.
This didn't actually work: the COPY succeeds, but the FREEZE
optimization isn't applied. There doesn't seem to be an easy way
to support FREEZE on foreign tables, so let's follow the precedent
established by commit 5c9a5513a3 by raising an error early. This
is arguably a bug fix, but due to the lack of reports, the minimal
discussion on the mailing list, and the potential to break existing
scripts, I am not back-patching it for now.
Author: Sami Imseih <samimseih@gmail.com>
Reviewed-by: Zhang Mingli <zmlpostgres@gmail.com>
Discussion: https://postgr.es/m/CAA5RZ0ujeNgKpE3OrLtR%3DeJGa5LkGMekFzQTwjgw%3DrzaLufQLQ%40mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/copy.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index 8394402f096..df093da97c5 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -237,7 +237,7 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable or truncated in the current subtransaction, there are no cursors open and there are no older snapshots held by this transaction. It is currently not possible to perform a <command>COPY FREEZE</command> on - a partitioned table. + a partitioned table or foreign table. This option is only allowed in <command>COPY FROM</command>. </para> <para> |