On 06/21/2013 10:39 AM, Lonni J Friedman wrote:
Greetings,
I'm trying to test out the new postgres-fdw support in postgresql-9.3
(beta) in preparation for an upgrade from 9.2 later this year. So
far, everything is working ok, however one problem I'm encountering is
with the COPY command. When I run it against a foreign table (which is
also in a 9.3 instance), it fails:
COPY my_foreigntbl (id,testname) TO '/tmp/testlist_aid' (DELIMITER ',');
ERROR: cannot copy from foreign table "my_foreigntbl"
Is this expected behavior or a bug?
Expected I believe:
http://www.postgresql.org/docs/9.3/static/postgres-fdw.html
"Now you need only SELECT from a foreign table to access the data stored
in its underlying remote table. You can also modify the remote table
using INSERT, UPDATE, or DELETE. "
thanks!
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
