Re: Heikki Linnakangas 2014-08-21 <53f5a2d6.2050...@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
-- 
c...@df7cb.de | http://www.df7cb.de/


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to