Re: 9.3-beta postgres-fdw COPY error

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(dot)klaver(at)gmail(dot)com