Re: [PATCH] Fix column name escaping in postgres_fdw stats import

From: Zhenwei Shang <a934172442(at)gmail(dot)com>
To: Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>
Cc: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>, Alex Guo <guo(dot)alex(dot)hengchen(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, efujita(at)postgresql(dot)org
Subject: Re: [PATCH] Fix column name escaping in postgres_fdw stats import
Date: 2026-05-13 07:27:24
Message-ID: CABv9HUk9FbK3wchZ91EqeHRnrXg9p0_eWwX9sXe2SvfJkH==ew@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com> 于2026年5月12日周二 16:03写道:

> Hi Fujita-san,
>
> On Tue, 12 May 2026 at 13:06, Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
> wrote:
>
>> Hi Ayush,
>>
>> On Mon, May 4, 2026 at 7:24 AM Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>
>> wrote:
>> > Are there some edits you would like me to make on the patch?
>>
>> One thing I noticed is the test case you added; it only tests
>> departing column names with single quotes, but it's better to also
>> test that with backslashes, to confirm the patch addresses the issue
>> in [1] as well. So I updated the patch as such. New version
>> attached. Other than that the patch looks good to me, so I'll push it
>> if no objections from you (or anyone else).
>>
>>
> Thanks for the updated version, and for folding in the backslash case
> from [1].
>
> I confirmed that the patch applies cleanly on master and that
> make -C contrib/postgres_fdw check passes, including the new
> dtest_ftable case. The merged test seems a strict improvement.
>
> No objections from me.
>
> Regards,
> Ayush
>

The patch overall looks solid to me. A tiny suggestion, while here, would
it make sense to also add comma and brace column names to the test, as they
are classic array-literal hazards, like “col,comma” and “col{brace”?

Regards,
Zhenwei Shang

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Chao Li 2026-05-13 08:35:30 Re: Fix REPACK with WITHOUT OVERLAPS replica identity indexes
Previous Message Peter Smith 2026-05-13 07:11:18 Re: Proposal: Conflict log history table for Logical Replication