I was afraid someone would say that. Is this a limitation that might be removed in the future (like 9.4), or is there a technical reason why its not possible to do a COPY against a foreign table? On Fri, Jun 21, 2013 at 10:52 AM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote: > 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 -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman netllama@xxxxxxxxx LlamaLand https://netllama.linux-sxs.org -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
