Skip site navigation (1) Skip section navigation (2)

Re: problem with function loading

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Berényi Gábor <ber_(at)freemail(dot)hu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: problem with function loading
Date: 2005-02-23 17:04:06
Message-ID: 20050223170406.GA27515@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-hackers
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/

In response to

Responses

pgsql-hackers by date

Next:From: Pailloncy Jean-GerardDate: 2005-02-23 19:31:25
Subject: PostgreSQL Soft RAID 1
Previous:From: Berényi GáborDate: 2005-02-23 15:53:34
Subject: problem with function loading

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group