Re: UUID generation problem

Hi James,

> On 03. Oct, 2020, at 04:17, James B. Byrne <byrnejb(at)harte-lyne(dot)ca> wrote:
>
> On Fri, October 2, 2020 21:13, Tom Lane wrote:
>> "James B. Byrne" <byrnejb(at)harte-lyne(dot)ca> writes:
>>> On Fri, October 2, 2020 18:46, Tom Lane wrote:
>>
>>> idempiere=# \dn
>>> List of schemas
>>> Name | Owner
>>> -----------+-----------
>>> adempiere | adempiere
>>> public | postgres

> I will resolve the conflict either by granting 'idempiere_dbadmin' the
> necessary privileges or by changing the connection to use the 'adempiere' user
> instead.

you can also rename roles/users:

alter role adempiere_dbadmin rename to idempiere_dbadmin;

https://www.postgresql.org/docs/13/sql-alterrole.html

or schema:

alter schema adempiere rename to idempiere;

https://www.postgresql.org/docs/13/sql-alterschema.html

Cheers,
Paul