Re: Postgresql gives error that role goes not exists while it exists

From: Euler Taveira <euler(at)timbira(dot)com(dot)br>
To: Nick Dro <postgresql(at)walla(dot)co(dot)il>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Postgresql gives error that role goes not exists while it exists
Date: 2017-10-03 12:47:32
Message-ID: CAHE3wghg7Er=X7aRR-pSazsj-i5Zjc4KxuUQUDKFJpxvySHDbA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2017-10-03 5:49 GMT-03:00 Nick Dro <postgresql(at)walla(dot)co(dot)il>:
> Can someone assists with the issue posted on StackOverflow?
>
> https://stackoverflow.com/questions/46540537/postgresql-9-3-creation-of-group-role-causes-permission-problems
>
>
> Creation of new Group Role causes postgresql to think that Login roles does
> not exist. I think it's a bug? or at least a wrong error message
>
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.

--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashutosh Bapat 2017-10-03 12:57:05 Re: Partition-wise join for join between (declaratively) partitioned tables
Previous Message Stephen Frost 2017-10-03 12:22:27 Re: Logging idle checkpoints