Re: postgres_fdw: wrong results with self join + enable_nestloop off

Richard Guo <guofenglinux@gmail.com>

From: Richard Guo <guofenglinux@gmail.com>

To: Suraj Kharage <suraj.kharage@enterprisedb.com>

Cc: Etsuro Fujita <etsuro.fujita@gmail.com>, Nishant Sharma <nishant.sharma@enterprisedb.com>, pgsql-hackers@postgresql.org

Date: 2023-06-05T03:06:11Z

Lists: pgsql-hackers

On Fri, Jun 2, 2023 at 11:30 AM Suraj Kharage <
suraj.kharage@enterprisedb.com> wrote:

> +1 for fixing this in the backend code rather than FDW code.
>
> Thanks, Richard, for working on this. The patch looks good to me at
> a glance.
>

Thank you Suraj for the review!

Thanks
Richard

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Re-allow FDWs and custom scan providers to replace joins with pseudoconstant quals.
- 9e9931d2bf40 17.0 landed
Disallow replacing joins with scans in problematic cases.
- db01f26968f2 11.21 landed
- 9edf72aa7644 12.16 landed
- 730f983effa5 13.12 landed
- b0e390e6d1d6 14.9 landed
- d1ef5631e620 15.4 landed
- 695f5deb7902 16.0 landed
- 6f80a8d9c137 17.0 landed
doc: PQinitOpenSSL and PQinitSSL are obsolete in OpenSSL 1.1.0+
- 928e05ddfd40 16.0 cited