Re: UUID generation problem

Hi James,

> On 05. Oct, 2020, at 17:57, James B. Byrne <byrnejb@harte-lyne.ca> wrote:
>
> [root@accounting-2 ~ (master)]# psql --dbname=idempiere
> --username=idempiere_dbadmin
> Password for user idempiere_dbadmin:
> psql (11.8)
> Type "help" for help.
>
> idempiere=# select current_schemas(true);
>    current_schemas
> ------------------------
> {adempiere,pg_catalog}
> (1 row)
>
> idempiere=# select uuid_generate_v4();
> ERROR:  function uuid_generate_v4() does not exist
> LINE 1: select uuid_generate_v4();
>               ^
> HINT:  No function matches the given name and argument types. You might need to
> add explicit type casts.
> idempiere=# select public.uuid_generate_v4();
>           uuid_generate_v4
> --------------------------------------
> 066e3298-3c91-4079-98ee-2b279bfc4025
> (1 row)

just out of curiosity, what does the search_path contain? It needs not necessarily reflect the contents of
current_schemas,see the following example: 

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

postgres=# select current_schemas(false);
  current_schemas
-------------------
 {postgres,public}
(1 row)

postgres=# show search_path;
   search_path
-----------------
 "$user", public
(1 row)

Cheers,
Paul