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@xxxxxxxxxxxxx> 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
