Re: UUID generation problem

On 10/5/20 12:09 PM, James B. Byrne wrote:
>
>
> On Mon, October 5, 2020 13:46, Adrian Klaver wrote:
>> The thing is, from upstream:
>>
>> 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)
>>
>> This indicates that you created the extension as user 'postgres'.
>>
>
> Why would I not use the postgres user to create an extension?
>

The uuid-extension needs to be installed by a super user:

test(5432)=> select current_user;
current_user
--------------
aklaver

test(5432)=> create extension "uuid-ossp" ;
ERROR: permission denied to create extension "uuid-ossp"
HINT: Must be superuser to create this extension.

test(5432)=> \c - postgres
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384,
bits: 256, compression: off)
You are now connected to database "test" as user "postgres".
test(5432)=# create extension "uuid-ossp" ;
CREATE EXTENSION

So postgres is probably as good as any.

I was just pointing out that what you posted earlier:

2000 2020-09-11 16:15:17: psql -d idempiere -U adempiere -c 'CREATE
EXTENSION
"uuid-ossp"'

2001 2020-09-11 16:17:08: su idempiere -c" psql -d idempiere -U
adempiere -c
'CREATE EXTENSION "uuid-ossp"

does not match what you showed for the actual installed code:

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 |

NOTE: Owner = postgres.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com