aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorSimon Riggs <simon@2ndQuadrant.com>2012-12-07 12:59:05 +0000
committerSimon Riggs <simon@2ndQuadrant.com>2012-12-07 12:59:05 +0000
commit1eb6cee499d19fc9204e059ba37fc2dac32e2f25 (patch)
tree23eb7ca24a98a04a6fb03fba61bd1607fce48a56 /doc/src
parent31a891857a128828d47d93c63e041f3b69cbab70 (diff)
downloadpostgresql-1eb6cee499d19fc9204e059ba37fc2dac32e2f25.tar.gz
postgresql-1eb6cee499d19fc9204e059ba37fc2dac32e2f25.zip
Clarify that COPY FREEZE is not a hard rule.
Remove message when FREEZE not honoured, clarify reasons in comments and docs.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/copy.sgml8
1 files changed, 5 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml
index 6d34c319888..6a0fabc978d 100644
--- a/doc/src/sgml/ref/copy.sgml
+++ b/doc/src/sgml/ref/copy.sgml
@@ -186,17 +186,19 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable
<term><literal>FREEZE</literal></term>
<listitem>
<para>
- Specifies copying the data with rows already frozen, just as they
+ Requests copying the data with rows already frozen, just as they
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.
+ 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.
</para>
<para>
- Note that all sessions will immediately be able to see the data
+ 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.