| From: | Christoph Berg <cb(at)df7cb(dot)de> |
|---|---|
| To: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
| Cc: | Viswanatham kirankumar <viswanatham(dot)kirankumar(at)huawei(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [TODO] Process pg_hba.conf keywords as case-insensitive |
| Date: | 2014-08-21 08:27:24 |
| Message-ID: | 20140821082723.GB4910@msg.df7cb.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Re: Heikki Linnakangas 2014-08-21 <53F5A2D6(dot)2050208(at)vmware(dot)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(at)df7cb(dot)de | http://www.df7cb.de/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2014-08-21 09:12:25 | Re: run xmllint during build (was Re: need xmllint on borka) |
| Previous Message | Christoph Berg | 2014-08-21 08:23:49 | Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED |