Re: patch: SQL/MED(FDW) DDL
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: Itagaki Takahiro <itagaki.takahiro@gmail.com>
Cc: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, SAKAMOTO Masahiko <sakamoto.masahiko@oss.ntt.co.jp>, pgsql-hackers@postgresql.org
Date: 2010-09-24T12:13:54Z
Lists: pgsql-hackers
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