Re: ERROR: language "c" is not trusted

http://www.faqs.org/docs/ppbook/r24435.htm

> -----Original Message-----
> From: Chris Albertson [mailto:chrisalbertson90278(at)yahoo(dot)com]
> Sent: Tuesday, July 01, 2003 4:45 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] ERROR: language "c" is not trusted
>
>
> I do the following as the user "postgres"
>
> alberts=# CREATE FUNCTION foobar(CSTRING)
> alberts-# RETURNS opaque
> alberts-# AS '$libdir/mystuff' , 'foobar'
> alberts-# LANGUAGE 'c'
> alberts-# WITH (isstrict,iscachable);
> CREATE FUNCTION
>
> Next I'd like to be able to use the funtion as a "normal"
> user so I thy this:
>
> grant USAGE ON LANGUAGE c TO alberts;
> ERROR: language "c" is not trusted
>
> OK, now what?
>
>
>
>
>
> =====
> Chris Albertson
> Home: 310-376-1029 chrisalbertson90278(at)yahoo(dot)com
> Cell: 310-990-7550
> Office: 310-336-5189 Christopher(dot)J(dot)Albertson(at)aero(dot)org
> KG6OMK
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index
> scan if your
> joining column's datatypes do not match
>