Re: User got created with first letter capitalized

[Keith <keith@xxxxxxxxxxx>]

On Mon, Jul 25, 2016 at 11:51 AM, John Scalia <jayknowsunix@xxxxxxxxx> wrote:

I have a user who was inserted into the db by one of our automation scripts. His ID has the very first letter capitalized.  The script reads the users from the appropriate Active Directory group and makes sure they exist in the database.

For grins, let's say the user is good old Charley Brown and is called "Cbrown1" in Active Directory. If I look for him by rolname in either pg_authid or the pg_roles view, He shows as:

rolname
-----------

Cbrown1

(1 row)

but when I try then to get rid of him using either "DROP ROLE cbrown1;" or "DROP ROLE Cbrown1;" I receive "ERROR: role "cbrown1" does not exist. Note that I get the error with the name in all lower case regardless of which way I specify him.

Also, he does not show up using \du Cbrown1 or \du+ cbrown1, but does show if I enter \du without specifying his id.

Anyone know what's going on with this?
--

Jay

Surround the role name with double-quotes. Otherwise postgres converts all object names to lowercase.

 

DROP ROLE "Cbrown1";

Keith