Re: postgres_fdw bug in 9.6

Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>

From: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>

To: Jeff Janes <jeff.janes@gmail.com>

Cc: Robert Haas <robertmhaas@gmail.com>, Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2017-01-18T02:48:35Z

Lists: pgsql-hackers

Attachments

epqpath-for-foreignjoin-4.patch (text/x-patch) patch
(unnamed) (text/plain)

On 2017/01/16 11:38, Etsuro Fujita wrote:
> On 2017/01/14 6:39, Jeff Janes wrote:
>> I do get a compiler warning:
>>
>> foreign.c: In function 'CreateLocalJoinPath':
>> foreign.c:832: warning: implicit declaration of function
>> 'pathkeys_contained_in'

> Will fix.

Done.  Attached is the new version.  I also adjusted the code a bit further.

Best regards,
Etsuro Fujita

Commits

Fix test case for 'outer pathkeys do not match mergeclauses' fix.
- d397f558d555 9.6.7 landed
- 92123c6ea212 10.2 landed
- 99f6a17dd62a 11.0 landed
postgres_fdw: Avoid 'outer pathkeys do not match mergeclauses' error.
- 4a81c022975e 9.6.7 landed
- 3f05a30b50a7 10.2 landed
- 4bbf6edfbd5d 11.0 landed
postgres_fdw: Consider foreign joining and foreign sorting together.
- aa09cd242fa7 9.6.0 cited
Allow foreign and custom joins to handle EvalPlanQual rechecks.
- 385f337c9f39 9.6.0 cited
Allow FDWs to push down quals without breaking EvalPlanQual rechecks.
- 5fc4c26db512 9.6.0 cited