On 10/6/20 9:35 AM, James B. Byrne wrote:
> Thank you all for the help. This is what ultimate resolved the issue for me:
>
>
> [root(at)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(at)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}
>
>
I wonder what affect installing uuid-ossp in template1 /before/ starting
with the idempiere installation might have had. Such that 'create
database idempiere;' would have put all the related functions in place
immediately?