Re: Trusted versus untrusted Pl language

2020-12-24 Thread Steven Pousty
On Wed, Dec 23, 2020 at 4:49 PM Bruce Momjian wrote: > On Wed, Dec 23, 2020 at 07:38:16PM -0500, Tom Lane wrote: > > Steven Pousty writes: > > > 3. An example of how to make a pre-installed untrusted langue into a > > > trusted language > > > > Under what circumstances would that be a good idea?

Re: Trusted versus untrusted Pl language

2020-12-24 Thread David G. Johnston
On Thu, Dec 24, 2020 at 1:01 PM Steven Pousty wrote: > The SQL I am talking about is this: > UPDATE pg_language SET lanpltrusted = true WHERE lanname LIKE 'plr'; > You seem to be missing the point. The language is either trusted, or it's not. Modifying the catalogs is not part of a "good flow"

Re: Trusted versus untrusted Pl language

2020-12-24 Thread Steven Pousty
Ok David but that is not what I have heard from a lot of other people in the PostgreSQL community. On Thu, Dec 24, 2020 at 1:26 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Dec 24, 2020 at 1:01 PM Steven Pousty > wrote: > >> The SQL I am talking about is this: >> UPDATE pg

Re: Trusted versus untrusted Pl language

2020-12-24 Thread Stephen Frost
Greetings, * Steven Pousty (steve.pou...@gmail.com) wrote: > If you consider the application developer or data scientist's perspective > it makes total sense. I don't like the pattern of appdevs always working as > the postgres user, it encourages bad patterns and can often blow up when > you move