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@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.klaver@aklaver.com