Re: [HACKERS] Postgresql gives error that role goes not exists whileit exists

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [HACKERS] Postgresql gives error that role goes not exists whileit exists
Дата
Msg-id CA+TgmoYDrtJQFOxzkkZiKzuPN3dv__-+qbeRQVc2B+_6pk9VKg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Postgresql gives error that role goes not exists whileit exists  (Euler Taveira <euler@timbira.com.br>)
Ответы Re: [HACKERS] Postgresql gives error that role goes not exists while it exists  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] cache lookup errors for missing replication origins
Следующее
От: Erik Rijkers
Дата:
Сообщение: [HACKERS] v10 bottom-listed