Re: Status of FDW pushdowns - Mailing list pgsql-hackers

From Atri Sharma
Subject Re: Status of FDW pushdowns
Date
Msg-id CAOeZVidcGg-GqyOzZ9DKnZ-OuKx+b_enFN1gJnCtX+9xX1F2aw@mail.gmail.com
Whole thread Raw
In response to Re: Status of FDW pushdowns  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: Status of FDW pushdowns  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List pgsql-hackers
On Wed, Nov 27, 2013 at 11:08 PM, Dimitri Fontaine
<dimitri@2ndquadrant.fr> wrote:
> Atri Sharma <atri.jiit@gmail.com> writes:
>> This would work,but how can we do it for FDWs which do not parse SQL?
>> Am I missing something here?
>
> Worst case:
>
>   CREATE FOREIGN VIEW foo
>   AS $$
>     whatever syntax is accepted on the other side


That doesnt sound like a very good idea.

Can we add a function to the FDW API to define a SQL to foreign server
side conversion?

I am just musing though.

Regards,

Atri



-- 
Regards,

Atri
l'apprenant



pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Status of FDW pushdowns
Next
From: Jeff Janes
Date:
Subject: Re: Handling GIN incomplete splits