CODEWITHSUNDEEP
ruby-on-railspostgresqlrolescase-sensitive
vbsql7
vbsql7

Reputation: 714

Role names are case sensitive in Postgres

Whoever made role names case sensitive is just evil.

I killed a couple of hours trying to figure out why rake commands did not work from the DOS command line in Windows. The error kept saying that role 'Michael' did not exist when I knew perfectly well that I had created it.

Adding insult to injury, the psql command -c "CREATE ROLE Michael ..." created the role alright, but in all lower case.

Upvotes: 3

Views: 2476

Answers (1)

vbsql7
vbsql7

Reputation: 714

I finally used pgAdmin to change the first letter of the role to uppercase 'M' and then all my commands worked as my Windows user name was passed into the various processes.

Designers -- pay attention to what you're doing! There's no reason for role names to be case sensitive.

Upvotes: 2

Related Questions