Horton

Re: ORDER BY pushdowns seem broken in postgres_fdw

David Zhang <david.zhang@highgo.ca>

View thread View on postgr.es
From: David Zhang <david.zhang@highgo.ca>
To: pgsql-hackers@lists.postgresql.org
Cc: Ronan Dunklau <ronan@dunklau.fr>
Date: 2021-09-03T20:54:25Z
Lists: pgsql-hackers 
The following review has been posted through the commitfest application:
make installcheck-world:  tested, failed
Implements feature:       tested, passed
Spec compliant:           not tested
Documentation:            not tested

Applied the v6 patch to master branch and ran regression test for contrib, the result was "All tests successful."

Commits

  1. Fix postgres_fdw to check shippability of sort clauses properly.

  2. postgres_fdw: Add ORDER BY to some remote SQL queries.