Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Postgresql gives error that role goes not exists whileit exists - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] Postgresql gives error that role goes not exists whileit exists
Date
Msg-id CA+TgmoYDrtJQFOxzkkZiKzuPN3dv__-+qbeRQVc2B+_6pk9VKg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Postgresql gives error that role goes not exists whileit exists  (Euler Taveira <euler@timbira.com.br>)
Responses Re: [HACKERS] Postgresql gives error that role goes not exists while it exists
List pgsql-hackers
Tree view 
On Tue, Oct 3, 2017 at 8:47 AM, Euler Taveira <euler@timbira.com.br> wrote:
> I'm not sure. I bet a dime that the role was created as "Iris" and you
> are trying to assing "iris" (they are different). If you list the
> roles, we can confirm that.

I don't see how this would explain anything.  "current_role"() is
going to return the role using its actual case, and that's also what
pg_hash_role() expects.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] cache lookup errors for missing replication origins
Next
From: Erik Rijkers
Date:
Subject: [HACKERS] v10 bottom-listed