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 ?





---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to