Ignore this error. I did not create a superuser. That fixed the
From: Shahryar G. Hashemi
Sent: Monday, January 08, 2007 8:19 PM
Subject: ERROR: permission denied for language c
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
hydra=> CREATE FUNCTION plpgsql_call_handler() RETURNS
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 G. Hashemi DBA
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
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: navicat||Date: 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. Hashemi||Date: 2007-01-09 04:19:05|
|Subject: ERROR: permission denied for language c|