Re: FDW for PostgreSQL - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: FDW for PostgreSQL
Date
Msg-id CAHyXU0zUo2sSzXGhGc6kcJOYWUVXAiDmfED-MGbXQYo7rt6ekQ@mail.gmail.com
Whole thread Raw
In response to FDW for PostgreSQL  (Shigeru HANADA <shigeru.hanada@gmail.com>)
List pgsql-hackers
On Fri, Sep 14, 2012 at 9:25 AM, Shigeru HANADA
<shigeru.hanada@gmail.com> wrote:
> Hi all,
>
> I'd like to propose FDW for PostgreSQL as a contrib module again.
> Attached patch is updated version of the patch proposed in 9.2
> development cycle.

very nice.

>   - binary transfer (only against servers with same PG major version?)

Unfortunately this is not enough -- at least not without some
additional work. The main problem is user defined types, especially
composites.  Binary wire format sends internal member oids which the
receiving server will have to interpret.

merlin



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Detecting libpq connections improperly shared via fork()
Next
From: Andrew Dunstan
Date:
Subject: Re: Detecting libpq connections improperly shared via fork()