Re: UUID generation problem

Hi James,

> 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
> --------------------------------------
> 5ba19b69-ec8e-4d8e-8968-7c84eccc4351
> (1 row)

> On 05. Oct, 2020, at 18:51, James B. Byrne <byrnejb@harte-lyne.ca> wrote:
> idempiere=# show search_path;
>      search_path
> -----------------------
> adempiere, pg_catalog
> (1 row)

I guess that's why you don't see the uuid_generate_v4() function. I suggest you either fully qualify it, i.e.
public.uuid_generate_v4()or add public to your search path. 

Cheers,
Paul