The docs say:

"When a transaction is read-only, the following SQL commands are
disallowed: INSERT, UPDATE, DELETE, and COPY TO"

Actually, COPY FROM is the command we disallow. This must have been
overlooked when the read-only error was fixed in the COPY code.

Pointed out by Arul Shaji at Fujitsu.

Thanks

Gavin
Index: doc/src/sgml/ref/set_transaction.sgml
===================================================================
--- doc/src/sgml/ref/set_transaction.sgml       (revision 15)
+++ doc/src/sgml/ref/set_transaction.sgml       (working copy)
@@ -95,7 +95,7 @@
    read/write or read-only.  Read/write is the default.  When a
    transaction is read-only, the following SQL commands are
    disallowed: <literal>INSERT</literal>, <literal>UPDATE</literal>,
-   <literal>DELETE</literal>, and <literal>COPY TO</literal> if the
+   <literal>DELETE</literal>, and <literal>COPY FROM</literal> if the
    table they would write to is not a temporary table; all
    <literal>CREATE</literal>, <literal>ALTER</literal>, and
    <literal>DROP</literal> commands; <literal>COMMENT</literal>,
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to