Howdy!

createlang -U dbuser plpgsql dbname

Results in:

createlang: language installation failed: ERROR: permission denied
for language c

However, I can make it work with

createlang -U postgres plpgsql dbname

Is the latter preferred, or do I have something misconfigured?

Thanks,
Tad

--
Tad Marko <tmarko@metrosplash.com>


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Tad Marko <tmarko@metrosplash.com> writes:
> However, I can make it work with
> createlang -U postgres plpgsql dbname
> Is the latter preferred, or do I have something misconfigured?

Createlang has to be done as a superuser.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match