Re: patch: SQL/MED(FDW) DDL - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Re: patch: SQL/MED(FDW) DDL
Date
Msg-id AANLkTinFeoXvPeSsQnj2As4p+qynZ6thkE3GP-fSvjzS@mail.gmail.com
Whole thread Raw
In response to Re: patch: SQL/MED(FDW) DDL  (SAKAMOTO Masahiko <sakamoto.masahiko@oss.ntt.co.jp>)
List pgsql-hackers
On Thu, Sep 16, 2010 at 3:15 PM, SAKAMOTO Masahiko
<sakamoto.masahiko@oss.ntt.co.jp> wrote:
> This is designed to be used in the executor module.
> The API has some simple interfaces, such as FreeConnection,
> Open, Iterate, Close, ReOpen, and OnError.

Of course they are similar APIs mentioned in the SQL standard, but
I'm not sure they are enough for all purposes. For example, they
don't have planner hooks, but we will need them eventually to push
down ORDER BY and LIMIT into FDW.

We could learn from MySQL's storage engine interface, because
they are designed for flat file wrapper at first, but enhanced
with pains for condition push-down.

-- 
Itagaki Takahiro


pgsql-hackers by date:

Previous
From: Itagaki Takahiro
Date:
Subject: Re: Progress indication prototype
Next
From: Andrew Dunstan
Date:
Subject: Re: bad variable subst after "AS"