Re: Wildcard usage enhancements in .pgpass - Mailing list pgsql-hackers

From Alexey Klyukin
Subject Re: Wildcard usage enhancements in .pgpass
Date
Msg-id CAAS3tyKCzZm6iifFUWYOM-79QzRgRnCm8XVkQ20U6sPwLWridA@mail.gmail.com
Whole thread Raw
In response to Re: Wildcard usage enhancements in .pgpass  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Wildcard usage enhancements in .pgpass  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Hi Martijn,

On Sun, Nov 17, 2013 at 7:56 PM, Martijn van Oosterhout <kleptog@svana.org> wrote:
On Sat, Nov 16, 2013 at 09:26:33PM +0100, Alexey Klyukin wrote:
> Hi,
>
> Attached is the patch that improves usage of '*' wildcard in .pgpass,
> particularly in the host part. The use case is below.

Looks interesting, though I wonder if you could use fnmatch(3) here. Or
woud that match more than you expect?  For example, it would allow
'foo*bar' to match 'foo.bar' which your code doesn't.

fnmatch(3) looks like a good deal and I'd certainly consider it if we go the road of matching regular expressions, although for simpler use cases it's an overkill, since it forces us to do an extra pass over the string to be matched and introduces some performance penalties of using a regexp matching engine.
 
--
Regards,
Alexey Klyukin

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Extra functionality to createuser
Next
From: Abhijit Menon-Sen
Date:
Subject: Re: [PATCH] Use MAP_HUGETLB where supported (v3)