Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Etsuro Fujita <etsuro.fujita@gmail.com>
Cc: Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>, sean.johnston@edgeintelligence.com, pgsql-bugs@lists.postgresql.org, pgsql-hackers@lists.postgresql.org
Date: 2019-04-27T14:47:13Z
Lists: pgsql-bugs, pgsql-hackers 
Etsuro Fujita <etsuro.fujita@gmail.com> writes:
> On Sat, Apr 27, 2019 at 2:10 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> If we don't want to change what the core code does with fdw_exprs,
>> I think the only way to fix it is to hack postgres_fdw so that it
>> won't generate plans involving the problematic case.

> Seems reasonable.

>> See attached.

> I read the patch.  It looks good to me.  I didn't test it, though.

Thanks for looking!  Have a good vacation ...

			regards, tom lane

Commits

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