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