Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_ident.conf + regular expressions issue - Mailing list pgsql-bugs

From Alexey Shishkin
Subject Re: pg_ident.conf + regular expressions issue
Date
Msg-id CAL2LCjyXn0MHPg9=qKcSiv0vJ26vK2heh5B41KJd1Romp-Ed5w@mail.gmail.com
Whole thread Raw
In response to Re: pg_ident.conf + regular expressions issue  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
OK, what we have is:

"(?c)^(.*SMOKEYBEAR)$" does not match "smokeybear"

and at the same time:

"(?i)^(.*SMOKEYBEAR)$" does match "smokeybear"

How the latter is possible ?

best regards,
Alexey Shishkin


On Mon, Oct 21, 2024 at 9:39 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Alexey Shishkin <alexey.shishkin.01@gmail.com> writes:
> Let me rephrase my question about regular expressions + pg_ident.conf:
> - why test09 is successful, while test10 fails ?

I don't see why that one surprises you.  "/(?c)^(.*SMOKEYBEAR)$" does
not match "smokeybear".

                        regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_ident.conf + regular expressions issue
Next
From: Tom Lane
Date:
Subject: Re: pg_ident.conf + regular expressions issue