On Fri, Sep 24, 2010 at 5:56 AM, Itagaki Takahiro
<itagaki.takahiro@gmail.com> wrote:
> I think there are two type of FDWs. One is a simple flat file wrapper
> used by COPY FROM now, that doesn't require any planner hooks.
> Another is a connector to an external database, like as dblink, that
> should be integrated with the planner.
This is a good point. On the one hand, I do agree that the API for
simple things like processing CSV files shouldn't be overly complex.
So perhaps we could start with a simple API and extend it later. On
the other hand, understanding how some of the more complex cases ought
to work provides insight into handling the simpler cases. So I think
we should aim to have at least a sketch of a design for the whole
feature, and then if in phase 1 we want to implement only the easier
parts, that's OK.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company