Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wKBsb-000hjd-0d for pgsql-hackers@arkaria.postgresql.org; Tue, 05 May 2026 09:15:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wKBsa-00BBxe-0G for pgsql-hackers@arkaria.postgresql.org; Tue, 05 May 2026 09:15:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wKBsZ-00BBxV-1s for pgsql-hackers@lists.postgresql.org; Tue, 05 May 2026 09:15:47 +0000 Received: from mail-ed1-x52a.google.com ([2a00:1450:4864:20::52a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wKBsW-00000000HnE-3SYV for pgsql-hackers@postgresql.org; Tue, 05 May 2026 09:15:46 +0000 Received: by mail-ed1-x52a.google.com with SMTP id 4fb4d7f45d1cf-67c9616b4feso2520301a12.1 for ; Tue, 05 May 2026 02:15:45 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1777972544; cv=none; d=google.com; s=arc-20240605; b=IFeM265W4ctSvPY+iFQ3CXY1PgKBLWIIVByfPavt/ylfqs8QJaVvQeWw8VtRwsUvQW zFu/nYNUrG4GXthqAIoSUL1wocoACO4tdZuKV0KOmJvXojGAw79UdBRegvJuWJc3oUYS z8bNMOJwbVrHRvEJ+eyREmjbwyKbN8hTjIrj+1Wta8OHoZ6Dvk0WHHs7WV6WSJAIaTas 4qDJ5avtYq50analkKoFxik4i0LXiZiT+XpBVLg1oIzLokSJXmM98p9MCFfrBIOEdyVM l6gdW/4H0tME9OQxHT3gqpYcA/WcULTFfPjPf7xUFqjzFi/H382EUWJx/1eKZ1cWrKcg X0Nw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:reply-to:in-reply-to:references :mime-version:dkim-signature; bh=13MAkZsLpnwSkJk6Bb53n7RWG6vIzxh7HBoG3YPy1UY=; fh=7EcUnNeM3WF18tfiLRmHFdnni7+wsEx+LZe8zLTk3os=; b=WmOOreTLqZRMNwTFSJLCyiuuD5evyj4haZoA193HD1erUrXBS6t/nSOq0IQ0YfMpqG 0stXoC2mrjgjb0GPOYq29gmPjItAvnTvHOKuR7Yla1PzgS/4HAPtrREoV66Qd6MG9M/l 5tt8HyvpYh5eDOnwCG+rNW2venSGOy+vtID/MkEUiv6uaDjF8aV6dl6ak5Bm7nkv4t/g cuhfJFm2dI3RaxRgah2mLUeVzcXImFfFqINUnVzHpQcVHlfSR1sOTEGlosR2BBYj3NvC CwSqCTziUGbCdg8s/Ji72fT5CxeyXZvhO2mqYsQRa5VuQUB0VgmaPFaqL4fy+Y/Pl9qn 3YIg==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1777972544; x=1778577344; darn=postgresql.org; h=cc:to:subject:message-id:date:from:reply-to:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=13MAkZsLpnwSkJk6Bb53n7RWG6vIzxh7HBoG3YPy1UY=; b=KrMBms3Iuuin/20t1XHsv1mgCMa5K9JobkAfWFNMUJJqHTdb8yQtaDopHT2GrzMMET TP7ZCcN3Bm/vyqu1JJV5lwvSf4/hKy+htGRB1+Si0rwxb/PypP+M3VrFPWNMw23YM/mi huXN891F4aNSrW/js8cTY/PH50CTyVSlTuXDae0uOoZGYSc7OBtsQN6gs3YLJVTU/fTb IjeMaY82CCrClg8B/OJ0D+YLweHiPYKyCsaoPKztbeGuCgsX0c4dm31ZKotvwi4qfK40 ZvmceDcpKUB4xBARq8cLfB8/PZX1vDcpiXRIav7qBM7WfyNYzMLTfr9O8uxGJ90dERa2 oUlg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777972544; x=1778577344; h=cc:to:subject:message-id:date:from:reply-to:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=13MAkZsLpnwSkJk6Bb53n7RWG6vIzxh7HBoG3YPy1UY=; b=OO7RjCwB9dMIE9L6jWoQi2SFl99ksR2swBrA0UDUSzWYqfVq6X7IqK7lfnYy8mojJ7 BHT8fWskELu04w/JXuMR3UXfJjVeAaKwKnij11aWSm5YZk4wtUiVmS6E7fqefo81Oz85 qL8d79ArGV7FvZd/jCG91UWeUzufQIGA/GVOhoxowm2Sk7W9XF1JTViYyRYDZWQNEgJ5 Uetsu2Ft+ulYpbJYQawjCSnv2B/KqdePIH+MLrfiOH9EvsSNX1tu1HXmOn6+auRgnfGl xCVeuHjnbuZvMazWqiL/WNv50s2U7nkrTVf9enp70a5zwpSq1GlPY4pJ5bolpnTRX/Yd q8+A== X-Forwarded-Encrypted: i=1; AFNElJ/ENYeQ9xBHysB9/s2RS3b8CldNPK2csa6VhDgAN9mSZglR8KV9yqWAD1l3Zzkdi7q5NW4lDyvJ387xNTdd@postgresql.org X-Gm-Message-State: AOJu0Yy4cL9RdLG1WqgATC25dB5XxkeG4PM5vJfHc9nXz13I8DnrdAXg SAzq3It10ZlNh5/fa7j0uIrhLlnmidJelSmJD8rf6veTXeneLR2I/9w/eJFQSr+6rdpGa6oAjWz uh6Sqcl1shFpXr7LzKAXbyNrGgFOKXwA= X-Gm-Gg: AeBDiesiC6QI5Y8pc5p/EMHjh51ApHQgfU2fwpT16lXTDRe2GJVKzgLzZoURxswBUoM U2FvYeuxRPy7GqLFp1jlvRg4wwDcCr1Ch5SXiwO4P7q4tA5l4vcbLAX4YLCmpG5qWEZ9j5ToP+s C0JYvAOhHeTDNGM1D1TqxKbNf5fCVsMGS7eIeWcAG8wm58bCv2AkNMi5uTar78MLyT7A7a3p6+D sorjLhwl+mp/eBZkDAjW4FawYIAtvKNy8o0t0EYA2AvpeGv7f8W4D74/9RKWFJ2wz8FERHSCWLT IQJCl8JKptueIiaf9mlaHuVn8QRNxjPKSQ20j3wenj8VzJJjWqU= X-Received: by 2002:a05:6402:520b:b0:677:33bd:5a4a with SMTP id 4fb4d7f45d1cf-67c1ada21a0mr5732229a12.16.1777972543332; Tue, 05 May 2026 02:15:43 -0700 (PDT) MIME-Version: 1.0 References: <20260502.140304.670813149418899420.ishii@postgresql.org> <20260505.090124.365339750969814137.ishii@postgresql.org> <20260505.170845.1271951360939093763.ishii@postgresql.org> In-Reply-To: <20260505.170845.1271951360939093763.ishii@postgresql.org> Reply-To: assam258@gmail.com From: Henson Choi Date: Tue, 5 May 2026 18:15:29 +0900 X-Gm-Features: AVHnY4I61qQDA9jxyEdy1zS_u74M5Kupoth7v4apr8ypngdNU1lx7LK1Ok3XGBs Message-ID: Subject: Re: Row pattern recognition To: Tatsuo Ishii , jian.universality@gmail.com Cc: zsolt.parragi@percona.com, sjjang112233@gmail.com, vik@postgresfriends.org, er@xs4all.nl, jacob.champion@enterprisedb.com, david.g.johnston@gmail.com, peter@eisentraut.org, li.evan.chao@gmail.com, pgsql-hackers@postgresql.org Content-Type: multipart/alternative; boundary="000000000000dda66106510e7d1a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000dda66106510e7d1a Content-Type: text/plain; charset="UTF-8" Hi Tatsuo, Jian, Both coding-style items from Jian's review will be addressed and included in the next patch series. > 1. We need to add trailing commas to enum definitions. See > > > https://git.postgresql.org/cgit/postgresql.git/commit/?id=611806cd726fc92989ac918eac48fd8d684869c7 > > I forgot that. Thanks for reminding. > Three enum types introduced by the patch lack a trailing comma on the last enumerator: RPRNavKind, RPRNavOffsetKind, and RPRPatternNodeType. All three will be corrected in the next series. > > + (errcode(ERRCODE_SYNTAX_ERROR), > > The leading parenthesis is optional and can be removed, fewer > > parentheses are always better. > > See related discussion: > > https://postgr.es/m/202510100916.s2e6n3xiwvyc@alvherre.pgsql > > Right. I will review all other patches. The outer-parentheses pattern appears in 17 ereport() calls in parse_rpr.c and 2 in optimizer/plan/rpr.c. All 19 sites will be cleaned up in the next series. Jian, I will review your other patches as well. Best, Henson --000000000000dda66106510e7d1a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Tatsuo, Jian,

Both coding-style= items from Jian's review will be addressed and
included in the next= patch series.

> 1. We need to add = trailing commas to enum definitions. See
> https://git.postgresql.org/cgit/postgresql.git/commit/?id=3D611806cd= 726fc92989ac918eac48fd8d684869c7

I forgot that. Thanks for reminding.

Three e= num types introduced by the patch lack a trailing comma on the
last enum= erator: RPRNavKind, RPRNavOffsetKind, and RPRPatternNodeType.
All t= hree will be corrected in the next series.
=C2=A0
> + (errcode(ERRCODE_SYNTAX_= ERROR),
> The leading parenthesis is optional and can be removed, fewer
> parentheses are always better.
> See related discussion:
> https://postgr.es/m/202510100916.s2= e6n3xiwvyc@alvherre.pgsql

Right. I will review all other patches.

The outer-pare= ntheses pattern appears in 17 ereport() calls in
parse_rpr.c and 2 in op= timizer/plan/rpr.c.=C2=A0 All 19 sites will be
cleaned up in the next se= ries.

Jian, I will review your other patches as well.

<= div>Best,
Henson
--000000000000dda66106510e7d1a--