readthefuckingmanual.net

[SOLVED] ERROR: permission denied for language c

Error added: 2005-10-29T15:12:28Z

0 people waiting for the answer...

2 answers found.

Answer 106 (90.90909% helpful)

Only superusers can create stored procedures using C. This probably happened while attempting to install a new procedural language handler. As root:

# su - postgres
$ psql <target database>
target# CREATE FUNCTION ...;
CREATE FUNCTION
target# CREATE LANGUAGE ...;
CREATE LANGUAGE
\\q

Answer 127 (66.666664% helpful)

Also, only superusers should create stored procedures in C.

Use plPGSQL whenever possible, and SECURITY DEFINER only when necesary

Add an answer/solution

If you know the answer, please add your own solution below.
If you don't know, but find out later, please come back and share your answer - there will be other people struggling with this too.

If you want to be notified via email when this is solved, enter your email address here: