[SOLVED] Re: UUID generation problem

Thank you all for the help.  This is what ultimate resolved the issue for me:


[root@accounting-2 ~ (master)]#  psql -E --dbname=idempiere --username=postgres
--host=localhost
Password for user postgres:
psql (11.8)
Type "help" for help.

idempiere(5432)=#  select current_schemas(true);
   current_schemas
---------------------
 {pg_catalog,public}
(1 row)

idempiere(5432)=# ALTER ROLE idempiere_dbadmin SET search_path TO
adempiere,public;
ALTER ROLE

idempiere(5432)=# \q

[root@accounting-2 ~ (master)]#  psql -E --dbname=idempiere
--username=idempiere_dbadmin --host=localhost
Password for user idempiere_dbadmin:
psql (11.8)
Type "help" for help.

idempiere(5432)=#  select current_schemas(true);
        current_schemas
-------------------------------
 {pg_catalog,adempiere,public}


-- 
***          e-Mail is NOT a SECURE channel          ***
        Do NOT transmit sensitive data via e-Mail
   Unencrypted messages have no legal claim to privacy
 Do NOT open attachments nor follow links sent by e-Mail

James B. Byrne                mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3