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
