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 ch*****************@yahoo.com
Cell: 310-990-7550
Office: 310-336-5189 Ch*********************@aero.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