Re: How to create c language in postgresql database. Thanks.

Hi John,

Thanks. You guys are right. I check the database. The C programm is there. ----- but why our application team keep ask me to give them the superuser privileges to create the C function. Should they use the superuser to create the C function. if yes , why they need it?

Thanks.
Regards.

Grace

At 2012-06-13 02:14:06,"John R Pierce [via PostgreSQL]" <ml-node+s1045698n5712238h20(at)n5(dot)nabble(dot)com> wrote:
On 06/12/12 9:53 AM, leaf_yxj wrote:
> I need to create c language in the postgresql database. I only know to
> create as follows.
>
> Create language c ;
>

to clarify what tom said, you externally compile your C functions into
.so/.dll files, then bind them in with CREATE FUNCTION name(args)
RETURNS ..... AS 'path/filename' LANGUAGE C

see http://www.postgresql.org/docs/current/static/xfunc-c.html

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

If you reply to this email, your message will be added to the discussion below:
http://postgresql.1045698.n5.nabble.com/How-to-create-c-language-in-postgresql-database-Thanks-tp5712221p5712238.html
To unsubscribe from How to create c language in postgresql database. Thanks., click here.
NAML

--
View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-create-c-language-in-postgresql-database-Thanks-tp5712221p5712242.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.