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 1whlFo-000P9S-0Z for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Jul 2026 09:41:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1whlFm-00CGmJ-1d for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Jul 2026 09:41:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1whlFm-00CGmB-0X for pgsql-hackers@lists.postgresql.org; Thu, 09 Jul 2026 09:41:10 +0000 Received: from mail-wr1-x430.google.com ([2a00:1450:4864:20::430]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1whlFk-00000000RlJ-0cge for pgsql-hackers@lists.postgresql.org; Thu, 09 Jul 2026 09:41:10 +0000 Received: by mail-wr1-x430.google.com with SMTP id ffacd0b85a97d-47df440fcd5so693866f8f.3 for ; Thu, 09 Jul 2026 02:41:07 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1783590062; cv=none; d=google.com; s=arc-20260327; b=f0AiZ8AOxTWka3rNewY/67ZMZvQdZfFRyN/71Um2fkL1QES9/y05fdNWcie8sh3o1D kMoM54++qdpYCP9ZiCkIYQlQjoxgp708B8exL4PEFEMl3LB+jYV2zw5zJXUg4a9n+qGc kFmuuJz84pNSq1+4bEfF88Hq852z0K+6994A2tiAZ9bQ6V1K8n10vcnJwg2NOUGFenFh bUgSKf3hfJW8CMzEJs9TzwTEfc0yKakFlwnTjwsITABuZaRiwXKRfsOkdNVLjLjc/HsR JrDyRccuGu4BI9Y9AB+X0Y2FSzFzdU0hnh/wDIQ5s+V6JkCVF+bDvVDBRMgImgPPF+b5 lDMA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20260327; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=yhRmx/ySCH6zGI6IGfs4hkje4PShghH2j2KM2S++4rU=; fh=73XYg9Xz03QuNac87BerKTJb6lxIP888cIgDiMbI51U=; b=kedwdnw4bZYTKYzM5RfPxPtbI1wEBW+52V+THwEquWxS0XQzBflSe1S5FtQ2HB/hlc Wri1OTZFlH75IWbenGojNeQKpznbgaSh/eFIKt4kqUzeOdMTjaOBPLIoCBgXDlt1Jlk3 FShSOWztpRtiZYAytLWe9nlmUQWhhLr4EvniKin40LLrfDmQ5jjDMdoaAk+R6KuyPl2T GEfT7PAZvv73HJIY8vh0hL5Zx40g1kIy2SbUjcYvo22NTVBa2hj/HCqY7lMzTi8kfAnw GgtYi4S8TyoyCpLnJcQhac8kAp/mP8on6IDweqilYuw46eVn10HHawK5BAKq1nafKU8w pNmA==; darn=lists.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=1783590062; x=1784194862; darn=lists.postgresql.org; h=content-transfer-encoding:content-type:cc:to:subject:message-id :date:from:in-reply-to:references:mime-version:from:to:cc:subject :date:message-id:reply-to:content-type; bh=yhRmx/ySCH6zGI6IGfs4hkje4PShghH2j2KM2S++4rU=; b=T7O0I1nbJTleYI72ndwJOOnhYvl3SuK4oowotzlVuax49AAw46E11z9Invg48e8Kud +eSq1rEeD0r5mx19QrQ6+jRFUAIO6uJlozxR0qmfWtMAVHJQ1DVCYXp8VtJxS6p1jCt8 IJ1woyH81QlvVcDTjp1rJO99NJ5H4qsXMZ4EWvSwLx4F0CZzJxmfCqz8RY+uxX105AoY nCYuiL0m7mFP2LNE7nIRHig/pgI593LaMN72gVm4I+GuNqNtjKgBVxPdWr3tY6ofMykL iVV1kigCAonUWJQkhQD9ZKn1rYrMt4fMWTMw6uMscsWxqnO9vXCzFul+mjFTzLt1glXP nxLQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1783590062; x=1784194862; h=content-transfer-encoding:content-type:cc:to:subject:message-id :date:from:in-reply-to:references:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=yhRmx/ySCH6zGI6IGfs4hkje4PShghH2j2KM2S++4rU=; b=hzV0F+TqeqCV60SRC/R9UH7VVfaSPZZ2D5n8w769dRZY82kSunrsxh9YWHvSPfQKwU 7c/eWGcIGZWlmlnxpwwwzWt8eIrC3kYdHW551iugwEDTPWTqatCtg+D2VK4zuU/bQe/A iXHMNd9nttGAEeux1c6l0x70TXjrBNEMthBGSMVcTAX9DzneILmt8Xbyf3LhuSKl/dtM aXFV2kXFnM54ljc6M8M+3jKTOUtoNHP+wOHFgln3MXBOu3PTrPIa7uMc1nJBSG3hgGCZ 0NDC9HWDHCQdR4XYoQe+XLbPuat4/7Dp9jeaxYTKqPCmD06MNv3j2VBQFTXX9H6rsFHT TfqA== X-Forwarded-Encrypted: i=1; AHgh+Rq689TUOfcauMs+J1AesndcnN5MeVBvt8dGE4pq03Uh0G7z1ZXO2JNVBLvm7E4/YQnTQJumyDbOijTVAEeq@lists.postgresql.org X-Gm-Message-State: AOJu0Yx0w34QgREmMKCXLh00BbcGw/5bV1FByF3QwMoVlc6PnuwUHw0S yyfwGOefmbd4PrqKYdNEf1+p/YZmbMPpFkAN3PShprw33f5rL82XrIWU+v5YKaO3efzm++xK1PU hwlmV8AS8OkA+i8qcHcOLtMw9fssPsQs= X-Gm-Gg: AfdE7ck3EvNbb2xqqZJIaAyvNTGNR9LGisK2AhEm1Hc8dJMRKJFjf/wzw1oXJfp0PNs A9OqureFfEcopY+JXJRNIjQNKLY4itvC2VLzOZqjOZ9nISPjmWCNpZoiqEC6Uyoi2G6DPIfYq0p dHz6dfeuFx4QE9Z7Piz47iLn/+75jPUUsxLus2RwaqavZ1653jjtyDyhbmIif1wrJ0NEb8mpFvS nVbStvq+Ve+2StNKJRHnww5zAokhPDcSXtLti6kcutFm+s775doRZynqxgj4UoindKlY0luwJ/h 2eyBCG5Nh7m7mJym6yNZQsnG7E1oNPTNBietEwijUaRRa6bNn4HOtqsE2aFpEAq45SFuDTSQXij 7kkk6jaJG8YROiR2teGNNR6naJ/l+XLV683/3cOX1BMZloouBFDJ4yYFrRtECAEYxxhfslK8k X-Received: by 2002:a05:6000:4609:b0:473:a376:815e with SMTP id ffacd0b85a97d-47df07f6d9cmr6294496f8f.33.1783590061465; Thu, 09 Jul 2026 02:41:01 -0700 (PDT) MIME-Version: 1.0 References: <55f40114-0b00-4c6d-919d-c58641133d2b@eisentraut.org> In-Reply-To: <55f40114-0b00-4c6d-919d-c58641133d2b@eisentraut.org> From: Ashutosh Bapat Date: Thu, 9 Jul 2026 15:10:48 +0530 X-Gm-Features: AUfX_mz6_goq2fPEq02MXLXI3J5K0fUTQx-Lkiv1gJefRvjUuGCOraHwdijRfMs Message-ID: Subject: Re: [Bug] Add the missing RTE_GRAPH_TABLE case to transformLockingClause() To: Peter Eisentraut Cc: Ayush Tiwari , SATYANARAYANA NARLAPURAM , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jul 9, 2026 at 1:48=E2=80=AFPM Peter Eisentraut wrote: > > On 10.06.26 14:49, Ashutosh Bapat wrote: > >> Attached is v2-0001, rebased on master and addressing > >> the comments you added in case we plan on parking the feature > >> work for once v20 opens. > > Thanks. I revised it a bit. Reworded the commit message to describe > > user facing behaviour instead of the internals, which are quite > > obvious from the code changes. Other cases in transformLockingClause() > > don't mention XXX, they just have ereport(). Removed that comment. > > Also massaged comments in the test - we usually don't describe the > > expected behaviour or error when it is obvious from the output. > > Attached revised patch. > > Committed. > Thanks. > I also modified the comment that said "ignore JOIN, SPECIAL, ..." to > just say "ignore all other RTE kinds", because keeping that kind of list > up to date is silly. (RTE_SPECIAL hasn't existed in a long time.) That comment is useful since it confirms that the omission is intentional; however I agree that keeping it up to date is cumbersome. Maybe we need some way to tie the two switch cases so that unintentional omissions can be easily caught. --=20 Best Wishes, Ashutosh Bapat