Re: Test case for parameterized remote path in postgres_fdw

2023-08-30 Thread Etsuro Fujita
On Wed, Aug 16, 2023 at 6:45 PM Etsuro Fujita wrote: > On Wed, Aug 16, 2023 at 9:41 AM Richard Guo wrote: > > On Tue, Aug 15, 2023 at 7:50 PM Etsuro Fujita > > wrote: > >> So we should have modified the second one as well? Attached is a > >> small patch for that. > > > Agreed, nice catch! +1

Re: Test case for parameterized remote path in postgres_fdw

2023-08-16 Thread Etsuro Fujita
Hi Richard, On Wed, Aug 16, 2023 at 9:41 AM Richard Guo wrote: > On Tue, Aug 15, 2023 at 7:50 PM Etsuro Fujita wrote: >> So we should have modified the second one as well? Attached is a >> small patch for that. > Agreed, nice catch! +1 to the patch. Thanks for looking! Best regards, Etsuro

Re: Test case for parameterized remote path in postgres_fdw

2023-08-15 Thread Richard Guo
On Tue, Aug 15, 2023 at 7:50 PM Etsuro Fujita wrote: > So we should have modified the second one as well? Attached is a > small patch for that. Agreed, nice catch! +1 to the patch. Thanks Richard

Test case for parameterized remote path in postgres_fdw

2023-08-15 Thread Etsuro Fujita
Hi, While working on the join pushdown issue, I noticed this bit in commit e4106b252: --- parameterized remote path +-- parameterized remote path for foreign table EXPLAIN (VERBOSE, COSTS false) - SELECT * FROM ft2 a, ft2 b WHERE a.c1 = 47 AND b.c1 = a.c2; + SELECT * FROM "S 1"."T 1" a, ft2 b