Re: [Postgres-xc-general] work with foreign-data wrapper

[鈴木 幸市 <ko...@in...>]

So far, CREATE FOREIGN DATA WRAPPER, CREATE SERVER and CREATE USER MAPPING are blocked.   As Michael suggests, yes, it would be nice to connect to foreign data through coordinators or even datanodes. 

It's welcome if more people are involved in the test, not just development.   Contribution of the code is more than welcome.

Unfortunately, nobody dis these work mainly due to the resource.   it will be wonderful if anybody can join and contribute the code.   There are not reason that XC doesn't have to support FDW.

Best;
---
Koichi Suzuki

On 2013/10/17, at 13:11, Michael Paquier <mic...@gm...> wrote:

> On Thu, Oct 17, 2013 at 12:43 PM, Aris Setyawan <ari...@gm...> wrote:
>> Hi,
>> 
>> Can XC be used with [write-able] foreign-data wrapper? What I mean
>> here are push down optimization and data distribution.
> XC does not support itself fdw, but I don't see why there would be
> problems to have a Postgres server with a postgres_fdw connect to
> Coordinators for read/write operations or even Datanodes for read-only
> operations as the communication interface is the same as vanilla. Take
> care to use at least XC 1.1~ for the latter though.
> 
>> I imagine, If yes, we can have a cluster of not just postgresql node.
>> But we can have oracle or mysql or redis or unlimited cluster.
> Yep. Supporting FDW in XC would be fun as well. Patches welcome.
> -- 
> Michael
> 
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>