RE: (LOCK TABLE options) “ONLY” and “NOWAIT” are not yet implemented

From: <Shinya11(dot)Kato(at)nttdata(dot)com>
To: <masao(dot)fujii(at)oss(dot)nttdata(dot)com>, <bt21tanigaway(at)oss(dot)nttdata(dot)com>
Cc: <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: RE: (LOCK TABLE options) “ONLY” and “NOWAIT” are not yet implemented
Date: 2021-10-04 05:28:15
Message-ID: TYAPR01MB2896C8DF324DA02EF1857491C4AE9@TYAPR01MB2896.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>-----Original Message-----
>From: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
>Sent: Monday, October 4, 2021 1:59 PM
>To: bt21tanigaway <bt21tanigaway(at)oss(dot)nttdata(dot)com>; RDH 加藤 慎也/Kato,
>Shinya (NTT DATA) <Shinya11(dot)Kato(at)jp(dot)nttdata(dot)com>
>Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
>Subject: Re: (LOCK TABLE options) “ONLY” and “NOWAIT” are not yet
>implemented
>
>
>
>On 2021/10/04 11:17, bt21tanigaway wrote:
>>>>     else if (Matches("LOCK", MatchAny, "IN", "ACCESS|ROW") ||
>>>> -             Matches("LOCK", "TABLE", MatchAny, "IN",
>>>> "ACCESS|ROW"))
>>>> +             Matches("LOCK", "TABLE", MatchAny, "IN",
>"ACCESS|ROW")
>>>> +||
>>>> +             Matches("LOCK", "ONLY", MatchAny, "IN",
>"ACCESS|ROW")
>>>> +||
>>>> +             Matches("LOCK", "TABLE", "ONLY", MatchAny, "IN",
>>>> +"ACCESS|ROW"))
>>> I think this code is redundant, so I change following.
>>> ---
>>>     else if (HeadMatches("LOCK") && TailMatches("IN", "ACCESS|ROW"))
>>> ---
>>> I created the patch, and attached it. Do you think?
>> Thank you for update!
>> I think that your code is more concise than mine.
>> There seems to be no problem.
>
>The patch looks good to me, too. I applied cosmetic changes to it.
>Attached is the updated version of the patch. Barring any objection, I will commit
>it.
Thank you for the patch!
It looks good to me.

Regards,
Shinya Kato

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2021-10-04 05:31:24 Re: Skipping logical replication transactions on subscriber side
Previous Message Fabien COELHO 2021-10-04 05:10:30 Re: Triage on old commitfest entries