aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2013-01-26 13:33:24 -0500
committerBruce Momjian <bruce@momjian.us>2013-01-26 13:33:24 -0500
commit4deb57de7dcfb66f850f16c0324731fdf3d86d09 (patch)
treee72418260ea7649af2da9c9f5e59a2890dca0d79 /doc/src
parent7e2322dff30c04d90c0602d2b5ae24b4881db88b (diff)
downloadpostgresql-4deb57de7dcfb66f850f16c0324731fdf3d86d09.tar.gz
postgresql-4deb57de7dcfb66f850f16c0324731fdf3d86d09.zip
Issue ERROR if FREEZE mode can't be honored by COPY
Previously non-honored FREEZE mode was ignored. This also issues an appropriate error message based on the cause of the failure, per suggestion from Tom. Additional regression test case added.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/copy.sgml12
1 files changed, 4 insertions, 8 deletions
diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml
index 6a0fabc978d..2137c67cb4b 100644
--- a/doc/src/sgml/ref/copy.sgml
+++ b/doc/src/sgml/ref/copy.sgml
@@ -190,18 +190,14 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable
would be after running the <command>VACUUM FREEZE</> command.
This is intended as a performance option for initial data loading.
Rows will be frozen only if the table being loaded has been created
- in the current subtransaction, there are no cursors open and there
- are no older snapshots held by this transaction. If those conditions
- are not met the command will continue without error though will not
- freeze rows. It is also possible in rare cases that the request
- cannot be honoured for internal reasons, hence <literal>FREEZE</literal>
- is more of a guideline than a hard rule.
+ or truncated in the current subtransaction, there are no cursors
+ open and there are no older snapshots held by this transaction.
</para>
<para>
Note that all other sessions will immediately be able to see the data
once it has been successfully loaded. This violates the normal rules
- of MVCC visibility and by specifying this option the user acknowledges
- explicitly that this is understood.
+ of MVCC visibility and users specifying should be aware of the
+ potential problems this might cause.
</para>
</listitem>
</varlistentry>