From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Dhirendra Singh <dhirendraks@gmail.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Facing issue with cert authentication
Date: Thu, 22 Dec 2022 13:46:30 +0100
Message-ID: <40ba97d7584f20dbf04ebedfc02cb1b8a146f45e.camel@cybertec.at> (raw)
In-Reply-To: <CAEyh4sZM30wsy=tqCdm6ugsN9SrR1=DZ1CCwZ2JoGw_m+sUexA@mail.gmail.com>
References: <CAEyh4sbEsn0BAb5KXf_wUgoJVSd=9Nj4aNZP626zVPKdy4HmXw@mail.gmail.com>
<CAKFQuwY-q+=ZYa3aFSuwWJJVHc=ePB9v=xz5m+ZiWm8DyARAoQ@mail.gmail.com>
<CAEyh4sZM30wsy=tqCdm6ugsN9SrR1=DZ1CCwZ2JoGw_m+sUexA@mail.gmail.com>
On Thu, 2022-12-22 at 14:39 +0530, Dhirendra Singh wrote:
> On Thu, Dec 22, 2022 at 10:21 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
> > On Wed, Dec 21, 2022 at 9:25 PM Dhirendra Singh <dhirendraks@gmail.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').
> > >
> > > 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.
>
> 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 ?
That syntax is not supported by PostgreSQL, and I cannot think of a better
way that to create the role with an upper case "S".
Yours,
Laurenz Albe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, dhirendraks@gmail.com, david.g.johnston@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Facing issue with cert authentication
In-Reply-To: <40ba97d7584f20dbf04ebedfc02cb1b8a146f45e.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox