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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeremy Drake <pgsql(at)jdrake(dot)com>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL Hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [pgsql-patches] unprivileged contrib and pl install
Date: 2007-01-25 05:31:32
Message-ID: 14575.1169703092@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Jeremy Drake <pgsql(at)jdrake(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-01-25 05:33:41 Re: pg_get_domaindef
Previous Message Bruce Momjian 2007-01-25 04:37:09 Re: pg_get_domaindef

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-01-25 05:33:41 Re: pg_get_domaindef
Previous Message Bruce Momjian 2007-01-25 04:37:09 Re: pg_get_domaindef