Thread: Can non-superuser install c functions ?

I am transferring a database from a system where I am a pg superuser to
one where I am not.

The database uses tsearch2.  I am unable to install any of the
functions.  For example:

CREATE FUNCTION gtsvector_in(cstring) RETURNS gtsvector
    AS '$libdir/tsearch2', 'gtsvector_in'
    LANGUAGE c STRICT;

results in: permission denied for language c

Do I need to get the pg administrator to install my database ?

On Thu, Nov 09, 2006 at 04:04:33PM -0500, Rick Schumeyer wrote:
> I am transferring a database from a system where I am a pg superuser to
> one where I am not.

<snip>

> results in: permission denied for language c
>
> Do I need to get the pg administrator to install my database ?

Yes. Letting someone install C language functions is equivalent to
giving then access to all data in the database and possibly most of the
rest of the system. So it's restricted.

So yes, the pg superuser in charge of the cluster needs to install
tsearch2 for you. The rest you can do yourself.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.