Re: UUID generation problem - Mailing list pgsql-general

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