Re: PG13 Trusted Extension usability issue

2020-06-29 Thread Stephen Frost
Greetings, * Tom Lane (t...@sss.pgh.pa.us) wrote: > "Brad Nicholson" writes: > > Tom Lane wrote on 2020/06/26 02:47:25 PM: > >> I'm confused about your point here. postgresql_fdw has intentionally > >> *not* been marked trusted. That's partly because it doesn't seem like > >> outside-the-datab

Re: PG13 Trusted Extension usability issue

2020-06-26 Thread Tom Lane
"Brad Nicholson" writes: > Tom Lane wrote on 2020/06/26 02:47:25 PM: >> I'm confused about your point here. postgresql_fdw has intentionally >> *not* been marked trusted. That's partly because it doesn't seem like >> outside-the-database access is something we want to allow by default, >> but i

Re: PG13 Trusted Extension usability issue

2020-06-26 Thread Adrian Klaver
On 6/26/20 12:03 PM, Brad Nicholson wrote: Tom Lane wrote on 2020/06/26 02:47:25 PM: > From: Tom Lane > To: "Brad Nicholson" > Cc: pgsql-general@lists.postgresql.org > Date: 2020/06/26 02:51 PM > Subject: [EXTERNAL] Re: PG13 Trusted Extension usability is

RE: PG13 Trusted Extension usability issue

2020-06-26 Thread Brad Nicholson
Tom Lane wrote on 2020/06/26 02:47:25 PM: > From: Tom Lane > To: "Brad Nicholson" > Cc: pgsql-general@lists.postgresql.org > Date: 2020/06/26 02:51 PM > Subject: [EXTERNAL] Re: PG13 Trusted Extension usability issue > > "Brad Nicholson" writ

Re: PG13 Trusted Extension usability issue

2020-06-26 Thread Tom Lane
"Brad Nicholson" writes: > First, as a long time user of the pgextwlist extension, I'm happy to see > this functionality appearing in core. However, as a long term user of that > extension, I can say that ability to create an extension as a non-super > user is pretty limited in itself in a lot of

PG13 Trusted Extension usability issue

2020-06-26 Thread Brad Nicholson
First, as a long time user of the pgextwlist extension, I'm happy to see this functionality appearing in core. However, as a long term user of that extension, I can say that ability to create an extension as a non-super user is pretty limited in itself in a lot of cases. Many extensions both in