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