Re: UUID generation problem

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(dot)klaver(at)aklaver(dot)com