Re: Facing issue with cert authentication

It seems regex provides a way to convert the extracted string to lowercase
by using "\L\1". but this is also not working...seems not supported by
postgres.
Is there a way to convert the matched string to lowercase ?

Thanks,
Dhirendra.

On Thu, Dec 22, 2022 at 10:21 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Wed, Dec 21, 2022 at 9:25 PM Dhirendra Singh <dhirendraks(at)gmail(dot)com>
> wrote:
>
>>
>> I am using cert authentication to authenticate.
>> I have created a user with name S114546 (with uppercase 'S'). user
>> created is s114546 (with lowercase 's').
>>
>> isn't it strange behavior? while creating the user it ignores the case
>> but checks the case during authentication.
>>
>
> It is what it is...that you can write transient SQL with case-folding
> behavior doesn't mean other contexts (in this case the O/S) are going to
> behave the same way. Regardless, it is case-sensitive through-and-through
> which is not strange.
>
>
>>
> I can create the user with uppercase 'S' by double quoting the username.
>> but the script which creates the user will do the same for all users which
>> i do not want.
>>
>>
> It seems considerably easier to modify your database role creation
> compared to the PKI certification creation. I suggest you figure out what
> you can live with on that front.
>
> David J.
>