On Fri, Mar 9, 2012 at 8:50 PM, <spamik(at)yum(dot)pl> wrote:
> CREATE EXTENSION ltree;
> ERROR: permission denied to create extension "ltree"
> HINT: Must be superuser to create this extension.
>
> Why does ltree require superuser privledge? Is it dangerous and allow
> circumventing server security? No mention of this in manual so it is either
> documentation problem or a too strict check problem.
The bulk of ltree--1.0.sql contains commands which must be executed by
superuser (e.g. creating C language functions, or CREATE OPERATOR
CLASS).
And the text for appendix F[1] does in fact mention that contrib
modules will need to be installed by a superuser, so this restriction
is not entirely undocumented.
Josh
[1] http://www.postgresql.org/docs/devel/static/contrib.html