Thread: createlang problem with 8, what is correct?

createlang problem with 8, what is correct?

From
Tad Marko
Date:
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>


Re: createlang problem with 8, what is correct?

From
Tom Lane
Date:
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