From: | Chris Albertson <chrisalbertson90278(at)yahoo(dot)com> |
---|---|
To: | Dann Corbit <DCorbit(at)connx(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: language "c" is not trusted |
Date: | 2003-07-02 00:45:54 |
Message-ID: | 20030702004554.8011.qmail@web41307.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for the hint. This fixed it:
alberts=# UPDATE pg_language
SET lanpltrusted = true
WHERE lanname = 'c';
UPDATE 1
alberts=# grant USAGE ON LANGUAGE c TO alberts;
GRANT
--- Dann Corbit <DCorbit(at)connx(dot)com> wrote:
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Christian Imbeault | 2003-07-02 00:47:15 | Re: Duplicate key insert question |
Previous Message | Jean-Christian Imbeault | 2003-07-02 00:45:23 | Re: Duplicate key insert question |