Re: keywords in initdb are case-sensitive?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: keywords in initdb are case-sensitive?
Дата
Msg-id 1328195319-sup-3736@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: keywords in initdb are case-sensitive?  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: keywords in pg_hba.conf are case-sensitive?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Excerpts from Robert Haas's message of jue feb 02 11:39:29 -0300 2012:
> On Wed, Feb 1, 2012 at 11:45 PM, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> > In miracee's review of Peter's patch for new -A options in initdb (in
> > commitfest app only), it is noted that pg_hba.conf keyword parsing is
> > done in a case sensitive manner.  So if you write "Trust" rather than
> > "trust", it's not recognized.
> >
> > This seemed pretty nonsensical to me, and it's not documented, so I came
> > up with the trivial attached patch.
> >
> > Comparisons to user and database names and the like are unchanged and
> > thus require matching case.
>
> We have lots of things that are case-sensitive; I don't particularly
> see why this one should be different.

Err, postgresql.conf processing is case insensitive, which is the most
closely related example.  Are you saying we should make that case
sensitive as well?  What I'm saying is that I see no good reason for
keyword comparison to be case sensitive here.  We don't compare case on
SQL keywords either.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Abhijit Menon-Sen
Дата:
Сообщение: Re: JSON for PG 9.2
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: JSON output functions.