Re: making EXPLAIN extensible

On 22/5/2025 16:17, Robert Haas wrote:
> On Sat, May 3, 2025 at 2:44 PM Andrei Lepikhov <lepihov@gmail.com> wrote:
>> I have one additional proposal.
>>
>> I currently use this interface and have noticed that the parameter
>> `option_name` in the RegisterExtensionExplainOption routine is
>> case-sensitive. Since SQL treats our extended options as
>> case-insensitive, it would be beneficial to either add a comment
>> clarifying this behavior or forcedly convert incoming text constant to
>> lowercase.
> 
> I don't think this is really true. It's just standard identifier
> handling. You can have options with upper-case names if you quote
> them.
Sorry for my language. I meant that when you call function 
RegisterExtensionExplainOption(), it make sense if you write parameter 
`option_name` as "debug" or "deBug". On the user side 
case-insensitiveness works correctly, of course. Not sure about side 
effects if one extension will call this routine with "Debug" parameter 
and another one - "debuG".

-- 
regards, Andrei Lepikhov