Re: Extension disappearing act

2025-06-23 Thread Álvaro Herrera
On 2025-Jun-19, Dominique Devienne wrote: > Hi. Little mystery we don't understand. v17. > > Create new DB, owned by dedicated new ROLE. > Create extension (pgcrypto) in our case. Installed in public, owned by > DB owner role. > Create schemas and populate them inside the DB. I would investigate

Re: Extension disappearing act

2025-06-20 Thread Adrian Klaver
On 6/19/25 07:54, Dominique Devienne wrote: On Thu, Jun 19, 2025 at 4:18 PM Adrian Klaver wrote: On 6/19/25 06:09, Dominique Devienne wrote: Hi. Little mystery we don't understand. v17. Does 'all' include the public schema? No. We don't touch `public` at all, beside pgcrypto ending up insid

Re: Extension disappearing act

2025-06-20 Thread Merlin Moncure
On Thu, Jun 19, 2025 at 8:09 AM Dominique Devienne wrote: > Hi. Little mystery we don't understand. v17. > > Create new DB, owned by dedicated new ROLE. > Create extension (pgcrypto) in our case. Installed in public, owned by > DB owner role. > Create schemas and populate them inside the DB. > Th

Re: Extension disappearing act

2025-06-20 Thread Dominique Devienne
On Thu, Jun 19, 2025 at 6:35 PM Laurenz Albe wrote: > > On Thu, 2025-06-19 at 15:09 +0200, Dominique Devienne wrote: > > Hi. Little mystery we don't understand. v17. > > We're stumped for now. > > So are we. Why do you keep us guessing instead of posting a reproducer? Hi. Simply because there's

Re: Extension disappearing act

2025-06-20 Thread Tomas Vondra
On 6/20/25 09:35, Dominique Devienne wrote: > On Thu, Jun 19, 2025 at 6:35 PM Laurenz Albe wrote: >> >> On Thu, 2025-06-19 at 15:09 +0200, Dominique Devienne wrote: >>> Hi. Little mystery we don't understand. v17. >>> We're stumped for now. >> >> So are we. Why do you keep us guessing instead

Re: Extension disappearing act

2025-06-19 Thread Laurenz Albe
On Thu, 2025-06-19 at 15:09 +0200, Dominique Devienne wrote: > Hi. Little mystery we don't understand. v17. > > Create new DB, owned by dedicated new ROLE. > Create extension (pgcrypto) in our case. Installed in public, owned by > DB owner role. > Create schemas and populate them inside the DB. >

Re: Extension disappearing act

2025-06-19 Thread Dominique Devienne
On Thu, Jun 19, 2025 at 4:18 PM Adrian Klaver wrote: > On 6/19/25 06:09, Dominique Devienne wrote: > > Hi. Little mystery we don't understand. v17. > Does 'all' include the public schema? No. We don't touch `public` at all, beside pgcrypto ending up inside it. > > Of course, the DB owner role wa

Re: Extension disappearing act

2025-06-19 Thread Adrian Klaver
On 6/19/25 06:09, Dominique Devienne wrote: Hi. Little mystery we don't understand. v17. Create new DB, owned by dedicated new ROLE. Create extension (pgcrypto) in our case. Installed in public, owned by DB owner role. Create schemas and populate them inside the DB. This also creates roles assoc

Re: Extension disappearing act

2025-06-19 Thread Tomas Vondra
On 6/19/25 15:09, Dominique Devienne wrote: > Hi. Little mystery we don't understand. v17. > > Create new DB, owned by dedicated new ROLE. > Create extension (pgcrypto) in our case. Installed in public, owned by > DB owner role. > Create schemas and populate them inside the DB. > This also crea

Extension disappearing act

2025-06-19 Thread Dominique Devienne
Hi. Little mystery we don't understand. v17. Create new DB, owned by dedicated new ROLE. Create extension (pgcrypto) in our case. Installed in public, owned by DB owner role. Create schemas and populate them inside the DB. This also creates roles associated to those schemas. One of the schema is o