Re: 9.3-beta postgres-fdw COPY error

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

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama(at)gmail(dot)com
LlamaLand https://netllama.linux-sxs.org