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

From Dimitri Fontaine
Subject Re: Status of FDW pushdowns
Date
Msg-id m2y549jth5.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: Status of FDW pushdowns  (Atri Sharma <atri.jiit@gmail.com>)
Responses Re: Status of FDW pushdowns  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Atri Sharma <atri.jiit@gmail.com> writes:
> Can we add a function to the FDW API to define a SQL to foreign server
> side conversion?

I think that's not tenable. Even if you limit the discussion to the
postgres_fdw, some queries against past version will stop working
against new version (keywords changes, catalogs, default settings, etc).

I don't think you want to embed a full parser of every supported FOREIGN
version of PostgreSQL inside the postgres_fdw code, so I think the text
of the view needs to be an opaque string.

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



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: MultiXact bugs
Next
From: Tom Lane
Date:
Subject: Re: Another bug introduced by fastpath patch