Thanks for the hint. This fixed it:
alberts=# UPDATE pg_language SET lanpltrusted = true WHERE lanname = 'c'; UPDATE 1
alberts=# grant USAGE ON LANGUAGE c TO alberts;
GRANT
Ummm, I doubt that's really what you wanted, was it? Quoting the fine manual, with emphasis added:
USAGE
For procedural languages, allows the use of the specified language for the creation of functions in that language. This is the only type of
^^^^^^^^^^^^^^^^^^^^^^^^^
privilege that is applicable to procedural languages.
EXECUTE
Allows the use of the specified function and the use of any
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
operators that are implemented on top of the function. This is the only type of privilege that is applicable to functions. (This syntax works for aggregate functions, as well.)
Did you just want to allow non-superusers to execute C language functions, or create their own? The latter is a huge, gaping security hole, which is why the language is marked "untrusted".
Joe
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
