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

From Dimitri Fontaine
Subject Re: Status of FDW pushdowns
Date
Msg-id m2y549lpzp.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: Status of FDW pushdowns  (Shigeru Hanada <shigeru.hanada@gmail.com>)
Responses Re: Status of FDW pushdowns
List pgsql-hackers
Shigeru Hanada <shigeru.hanada@gmail.com> writes:
> I'm sorry but I don't see the point here.  Do you mean that user
> executes CREATE FOREIGN VIEW in advance and uses the view in a

Yes that's what I mean.

> I think it's nice to support executing ad-hoc remote query written in
> the syntax which is valid only on remote data source through FDW, and
> at the moment dblink interface seems feasible for that purpose.

I guess the view query would have to be validated by the FDW, which
would just receive a text.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Errors on missing pg_subtrans/ files with 9.3
Next
From: Tom Lane
Date:
Subject: Re: lock on object is already held