Обсуждение: 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@infospace.com  Numeric Pager: +1 877.252.5631
E-Mail: shashem@infospace.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.

Hi,

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

Shahryar

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@infospace.com  Numeric Pager: +1 877.252.5631
E-Mail: shashem@infospace.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.