From: | Lonni J Friedman <netllama(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: 9.3-beta postgres-fdw COPY error |
Date: | 2013-06-21 17:56:47 |
Message-ID: | CAP=oouE28WPkjFcoDmX4ypA9hosjsDg-6WcCdFyvPWUcsbz1HQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2013-06-21 18:00:42 | Re: File System backup |
Previous Message | Vibhor Kumar | 2013-06-21 17:56:21 | Re: 9.3-beta postgres-fdw COPY error |