Re: UUID generation problem

On 10/2/20 5:08 PM, James B. Byrne wrote:
>
>
> On Fri, October 2, 2020 18:14, Adrian Klaver wrote:
>
>>
>> Per comment over at SO, have you run uuid_generate_v4()/generate_uuid().
>> in psql to see if it is there and works?
>>
>
> [root(at)accounting-2 ~ (master)]# sudo -u postgres psql --dbname=idempiere
> --username=idempiere_dbadmin
> Password for user idempiere_dbadmin:
> psql (11.8)
> Type "help" for help.
>
> 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 uuid_generate();
> ERROR: function uuid_generate() does not exist
> LINE 1: select uuid_generate();
> ^
> HINT: No function matches the given name and argument types. You might need to
> add explicit type casts.
> idempiere=#
>
>

So per Tom's post:

What does:

show search_path;

return?

Also what does:

select public.uuid_generate_v4();

do?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com