Обсуждение: createlang problem with 8, what is correct?

Поиск
Список
Период
Сортировка

createlang problem with 8, what is correct?

От
Tad Marko
Дата:
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?

От
Tom Lane
Дата:
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