ERROR: permission denied for language c

[Jonathan Leto]

Howdy,

I am trying to get hacking on PL/Parort on a new machine, and when I run "make test" the first time, it complains that no database named "leto" exists. Easy enough to fix. Then it complains that plpgsql doesn't exist. Easy enough to fix. But then I get:

psql:plparrot.sql:3: ERROR:  permission denied for language c

What did I do wrong?

I would like to make it easier for users to run tests, so if anybody has ideas for how to make that happen, I would greatly appreciate it.

Duke


--
Jonathan "Duke" Leto
jona...@leto.net
http://leto.net

[Joshua Tolley]

On Tue, Sep 21, 2010 at 08:11:13PM -0700, Jonathan Leto wrote:
> psql:plparrot.sql:3: ERROR: permission denied for language c
>
> What did I do wrong?

You've got to be a superuser to add c-language functions. I'm guessing this is
when you're creating the language handler functions before creating the
plparrot language.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com