On 10/5/20 6:18 AM, James B. Byrne wrote:
On Sat, October 3, 2020 00:28, Adrian Klaver wrote:
I'm not sure that is going to help. You are not, AFAICT, getting any
permission denied messages.
What does:
\df+ uuid_generate_v4
show under Access privileges?
What does:
select current_schemas(true);
show?
idempiere=# \df+ uuid_generate_v4
List
of
functions
Schema | Name | Result data type | Argument data types | Type |
Volatility | Parallel | Owner | Security | Access privileges | Language |
Source code | Description
--------+------------------+------------------+---------------------+------+------------+----------+----------+----------+-------------------+----------+------------------+-------------
public | uuid_generate_v4 | uuid | | func |
volatile | safe | postgres | invoker | | c |
uuid_generate_v4 |
(1 row)
idempiere=# select current_schemas(true);
current_schemas
---------------------
{pg_catalog,public}
(1 row
So as same user:
select uuid_generate_v4();
select public.uuid_generate_v4();
\dn+ public
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
