Re: pg_ident.conf + regular expressions issue

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Alexey Shishkin <alexey(dot)shishkin(dot)01(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_ident.conf + regular expressions issue
Date: 2024-10-21 21:12:57
Message-ID: CAKFQuwaibErNPF+W7966B16ycFRJEk+trsVdJ73bQ1+Wm0mTBQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Monday, October 21, 2024, Alexey Shishkin <alexey(dot)shishkin(dot)01(at)gmail(dot)com>
wrote:

> 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 ?
>

I suggest you explain in your own words what those two regular expressions
are attempting to do. Why do you expect the second one to not match? Why
does the first one not match?

David J.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message px shi 2024-10-22 01:17:53 Re: BUG #18666: Standby cluster does not start after building from Primary cluster.
Previous Message Tom Lane 2024-10-21 21:04:48 Re: pg_ident.conf + regular expressions issue