Re: pg_execute_from_file, patch v10 - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: pg_execute_from_file, patch v10
Date
Msg-id 87pqt4bu7i.fsf@hi-media-techno.com
Whole thread Raw
In response to Re: pg_execute_from_file, patch v10  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:
> CREATE EXTENSION will be superuser to start with, no doubt, but I think
> we'll someday want to allow it to database owners, just as happened with
> CREATE LANGUAGE.  Let's not build it on top of operations that
> inherently involve security problems, especially when there's no need
> to.

That boils down to moving the superuser() test in the right functions,
it's now in the innermost facility to read files. If you have something
precise enough for me to work on it, please say, but I guess you'd spend
less time making the copy/paste in the code rather than in the mail.
That schedule optimisation is for you to make, though.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: pg_execute_from_file, patch v10
Next
From: Dimitri Fontaine
Date:
Subject: Re: pg_execute_from_file, patch v10