BUG #14498: Default role should be case sensitive when created in Windows

From: liomry(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14498: Default role should be case sensitive when created in Windows
Date: 2017-01-16 13:35:08
Message-ID: 20170116133508.1437.73697@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14498
Logged by: L Ryan
Email address: liomry(at)gmail(dot)com
PostgreSQL version: 9.6.1
Operating system: Windows 7
Description:

My windows username is "L", I'm new to PostgreSQL and was setting up for
ruby on rails using Webstorm.

Even when I created a "ruby" role with database and used -U for the command
line tools a lot of the Webstorm tools defaulted to using 'L' as they did
not set the -U switch.

I think it would be very helpful to automatically wrap the default role in
"" when creating it in the installer as Unix usernames will be lowercase
anyway and Windows users won't waste hours trying to troubleshoot various
tools which keep saying that the "L" role does not exist.

It seems like this is a very small change that will help prevent frustration
for new users trying out PostgreSQL

Browse pgsql-bugs by date

  From Date Subject
Next Message nikolay.nikitin 2017-01-16 13:37:33 BUG #14499: pg_dump error on the table with 512M or bigger bytea values
Previous Message nikolay.nikitin 2017-01-16 12:57:51 BUG #14497: 1G bytea insert error