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 <byrn...@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
