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@xxxxxxxxxxx
