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
And the text for appendix F does in fact mention that contrib
modules will need to be installed by a superuser, so this restriction
is not entirely undocumented.
In response to
pgsql-bugs by date
|Next:||From: adam.robertson||Date: 2012-03-11 20:46:41|
|Subject: BUG #6526: Intermittent connect issue|
|Previous:||From: Jeff Davis||Date: 2012-03-11 18:20:04|
|Subject: check_locale() and the empty string|