Re: parsing pg_ident.conf - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: parsing pg_ident.conf
Date
Msg-id 178cb53c-995e-9167-015d-16d1358eb70c@dunslane.net
Whole thread Raw
In response to Re: parsing pg_ident.conf  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: parsing pg_ident.conf  (Fabien COELHO <coelho@cri.ensmp.fr>)
List pgsql-hackers
On 11/20/20 2:19 AM, Fabien COELHO wrote:
>
> Hello Andrew,
>
>> I noticed somewhat to my surprise as I was prepping the tests for the
>> "match the whole DN" patch that pg_ident.conf is parsed using the same
>> routines used for pg_hba.conf, and as a result the DN almost always
>> needs to be quoted, because they almost all contain a comma e.g.
>> "O=PGDG,OU=Testing". Even if we didn't break on commas we would probably
>> need to quote most of them, because it's very common to include spaces
>> e.g. "O=Acme Corp,OU=Marketing". Nevertheless it seems rather odd to
>> break on commas, since nothing in the file is meant to be a list - this
>> is a file with exactly three single-valued fields. Not sure if it's
>> worth doing anything about this, or we should just live with it the way
>> it is.
>
> My 0.02 €:
>
> ISTM that having to quote long strings which may contains space or
> other separators is a good thing from a readability point of view,
> even if it would be possible to parse it without the quotes.
>
> So I'm in favor of keeping it that way.
>
> Note that since 8f8154a503, continuations are allowed on "pg_hba.conf"
> and "pg_ident.conf", and that you may continuate within a quoted
> string, which may be of interest when considering LDAP links.


Maybe we should add a comment at the top of the file about when quoting
is needed.


cheers


andrew




pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: don't allocate HashAgg hash tables when running explain only
Next
From: Andreas Karlsson
Date:
Subject: Re: Different results between PostgreSQL and Oracle for "for update" statement