Horton

Re: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault)

Etsuro Fujita <etsuro.fujita@gmail.com>

View thread View on postgr.es
From: Etsuro Fujita <etsuro.fujita@gmail.com>
To: Sean Johnston <sean.johnston@edgeintelligence.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>, pgsql-hackers@lists.postgresql.org
Date: 2019-05-24T19:30:41Z
Lists: pgsql-bugs, pgsql-hackers 
On Sat, May 25, 2019 at 2:19 AM Sean Johnston
<sean.johnston@edgeintelligence.com> wrote:
> Obviously this isn't mainstream postgres but just wondering if anyone has looked into issues with regards to pushing order/limit to remote nodes for fdw.

In PostgreSQL 12 Beta 1 released this week [1], we can push down ORDER
BY/LIMIT to the remote PostgreSQL server.  Give it a try!

Best regards,
Etsuro Fujita

[1] https://www.postgresql.org/about/news/1943/

Commits

  1. Avoid postgres_fdw crash for a targetlist entry that's just a Param.