Re: [pgsql-patches] unprivileged contrib and pl install - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [pgsql-patches] unprivileged contrib and pl install
Date
Msg-id 14575.1169703092@sss.pgh.pa.us
Whole thread Raw
In response to Re: [pgsql-patches] unprivileged contrib and pl install  (Jeremy Drake <pgsql@jdrake.com>)
List pgsql-hackers
Jeremy Drake <pgsql@jdrake.com> writes:
>> I am digging through the code looking at this, and I have a question.  As
>> far as I can tell, there is currently no owner for a pg_language entry.

Er, doh.

> Sort of answered my own question, found this comment:
>  * Note: for now, languages are treated as owned by the bootstrap
>  * user. We should add an owner column to pg_language instead.

> So in the course of implementing this, an owner column would probably need
> to be added to pg_language, I guess.

If you believe my idea that the DB owner ought to have special privilege
in this regard, then probably yes.  Alternatively, we could hard-wire
the treatment of the DB owner.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_trigger.tgargs needs detoast
Next
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Fix for plpython functions; return true/false for boolean,