Re: UUID generation problem

"James B. Byrne" <byrnejb@harte-lyne.ca> writes:
> 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
> --------------------------------------
>  87f70b3b-4dc5-4775-b8f7-b7a351e7b97b
> (1 row)

That seems to show quite definitively that public is not in your
search_path, which contradicts the current_schemas() result you
gave earlier.  I continue to suspect that you are somehow
confusing yourself by testing in different databases and/or
with different user accounts.

Possibly connected to this is that the "#" mark in your psql
prompt implies that you are running as superuser.  I sure
hope you are not letting your application do that.

            regards, tom lane