Обсуждение: problem with function loading

Dear Pg hackers,

After upgrading from 7.4.2 to 8.0.0 I get this message when trying to 
load a C language function:

permission denied for language c

Even postgres and root gets this message. SQL functions work well.

Please, help.

With love, Gabor

On Wed, Feb 23, 2005 at 04:53:34PM +0100, Berényi Gábor wrote:

> After upgrading from 7.4.2 to 8.0.0 I get this message when trying to 
> load a C language function:
> 
> permission denied for language c
> 
> Even postgres and root gets this message. SQL functions work well.

Are you sure "postgres" and "root" are database superusers?  What's
the result of the following query?

SELECT usename FROM pg_user WHERE usesuper IS TRUE;

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

Dear Michael and others,

> SELECT usename FROM pg_user WHERE usesuper IS TRUE;

Result: postgres. So the problem persist.

Does it work for you? I use x86 Linux 2.4.20.

Look forward to hear of you, Gabor


Michael Fuhr <mike@fuhr.org> írta:

> On Wed, Feb 23, 2005 at 04:53:34PM +0100, Berényi Gábor wrote:
>
> > After upgrading from 7.4.2 to 8.0.0 I get this message when trying
to
> > load a C language function:
> >
> > permission denied for language c
> >
> > Even postgres and root gets this message. SQL functions work
well.
>
> Are you sure "postgres" and "root" are database superusers?
What's
> the result of the following query?
>
> SELECT usename FROM pg_user WHERE usesuper IS TRUE;
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

On Wed, Feb 23, 2005 at 11:39:19PM +0100, Berényi Gábor wrote:
> 
> > SELECT usename FROM pg_user WHERE usesuper IS TRUE;
> 
> Result: postgres. So the problem persist.

Please show the exact statement you're running and the exact output
(copied and pasted, not typed manually).  Also the following, just
so we're all clear about what user you're running as:

SELECT * FROM pg_user WHERE usename = CURRENT_USER;

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/