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

Re: ERROR: permission denied for language c

From: "Shahryar G(dot) Hashemi" <Shahryar(dot)Hashemi(at)infospace(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: ERROR: permission denied for language c
Date: 2007-01-09 04:26:53
Message-ID: 8459AE1CDB7A0441A1ED87C375891E4602F6D9D4@EXCHIS5BV.inspinc.ad (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

 

Ignore this error.  I did not create a superuser.  That fixed the
problem.

 

Shahryar

 

________________________________

From: Shahryar G. Hashemi 
Sent: Monday, January 08, 2007 8:19 PM
To: 'pgsql-admin(at)postgresql(dot)org'
Subject: ERROR: permission denied for language c

 

Hi,

 

I have created a new user called hydra with 'createdb' permission.  I
can create the DB but when I run this command I get this error.  I did
the GRANT USAGE for LANGUAGE C to hydra.  But still the error.  Any
ideas?

 

hydra=>         CREATE FUNCTION plpgsql_call_handler() RETURNS
language_handler

hydra->             AS '$libdir/plpgsql', 'plpgsql_call_handler'

hydra->             LANGUAGE c;

ERROR:  permission denied for language c

 

I maybe doing something wrong.  Does the user need to be created
differently?  I am using pg_restore to restore a DB image.

 

Shahryar

 

--
Shahryar G. Hashemi                      DBA
InfoSpace Inc.
601 108th Ave NE Suite 1200
Bellevue, WA 98004 U.S.A.
Office: +1 425.201.8853                  Fax: +1 425.201.6160
Alpha Pager: page-shashem(at)infospace(dot)com  Numeric Pager: +1 877.252.5631
E-Mail: shashem(at)infospace(dot)com            WEB: http://infospaceinc.com
<http://infospaceinc.com/>  

This e-mail and any attachments may contain confidential information
that is legally privileged. The information is solely for the use of the
intended recipient(s); any disclosure, copying, distribution, or other
use of this information is strictly prohibited. If you have received
this e-mail in error, please notify the sender by return e-mail and
delete this message. Thank you.

 

pgsql-admin by date

Next:From: navicatDate: 2007-01-09 08:58:00
Subject: Navicat PostgreSQL Manager for Windows ver. 7.2.10 improves Access to PostgreSQL and Query Builder features
Previous:From: Shahryar G. HashemiDate: 2007-01-09 04:19:05
Subject: ERROR: permission denied for language c

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