Re: [TODO] Process pg_hba.conf keywords as case-insensitive - Mailing list pgsql-hackers

Re: Heikki Linnakangas 2014-08-21 <53F5A2D6.2050208@vmware.com>
> >1) database and role names behave similar to SQL identifiers (case-sensitive / case-folding).
> >
> >2) users and user-groups only requires special handling and behavior as follows
> >     Normal user :
> >       A. unquoted ( USER ) will be treated as user ( downcase ).
> >       B. quoted  ( "USeR" )  will be treated as USeR (case-sensitive).

> With this patch, database (and role?) names are compared case-insensitively.
> For example:
> 
> local  MixedDB all trust
> local  mixedDB all reject
> 
> psql -d "mixedDB"
> psql (9.5devel)
> Type "help" for help.
> 
> mixedDB=#
> 
> That connection should've matched that 2nd line, and be rejected.

Actually it should have matched neither, as both lines will get folded
downcase:

local  mixeddb all trust
local  mixeddb all reject

Christoph
-- 
cb@df7cb.de | http://www.df7cb.de/