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

2012-06-20 Thread yxj
Hi Albe, Thanks. I will study it. Regards. Grace At 2012-06-14 15:33:07,"Albe Laurenz" wrote: >leaf_yxj wrote: >> Thanks for your answers. I really appreciate it. Although I don't >understand the whole things you guys >> mentioned to me. I think maybe I should do it by myself. I need to

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

2012-06-14 Thread Albe Laurenz
leaf_yxj wrote: > Thanks for your answers. I really appreciate it. Although I don't understand the whole things you guys > mentioned to me. I think maybe I should do it by myself. I need to do a test. If there is any good > guide/white paper, please give me a link for me to study. I think the docu

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

2012-06-13 Thread leaf_yxj
Hi Chris and Guys, Thanks for your answers. I really appreciate it. Although I don't understand the whole things you guys mentioned to me. I think maybe I should do it by myself. I need to do a test. If there is any good guide/white paper, please give me a link for me to study. Thanks. Reg

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

2012-06-13 Thread Chris Travers
On Wed, Jun 13, 2012 at 12:19 AM, Craig Ringer wrote: > On 06/13/2012 12:45 PM, Chris Travers wrote: >> >> On Tue, Jun 12, 2012 at 11:47 AM, John R Pierce >> wrote: >>> >>> On 06/12/12 11:25 AM, leaf_yxj wrote: Thanks. You guys are right. I check the database. The C programm is the

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

2012-06-13 Thread Craig Ringer
On 06/13/2012 12:45 PM, Chris Travers wrote: On Tue, Jun 12, 2012 at 11:47 AM, John R Pierce wrote: On 06/12/12 11:25 AM, leaf_yxj wrote: 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 priv

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

2012-06-12 Thread Chris Travers
On Tue, Jun 12, 2012 at 11:47 AM, John R Pierce wrote: > On 06/12/12 11:25 AM, leaf_yxj wrote: >> >> 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. Sho

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

2012-06-12 Thread Craig Ringer
On 06/13/2012 03:35 AM, leaf_yxj wrote: Hi John, Thanks for your useful info. I really apprecaite it. I got this problem when the SAS application try to install the scoring model. So I am very confused. > 1) What's the info in .dll/.so ? thats the binary code compiled and linked from C, w

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

2012-06-12 Thread leaf_yxj
Hi John, Thanks for your useful info. I really apprecaite it. I got this problem when the SAS application try to install the scoring model. So I am very confused. > 1) What's the info in .dll/.so ? thats the binary code compiled and linked from C, windows calls this DLL (Dynamic Link Librar

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

2012-06-12 Thread John R Pierce
On 06/12/12 12:22 PM, leaf_yxj wrote: 1) What's the info in .dll/.so ? thats the binary code compiled and linked from C, windows calls this DLL (Dynamic Link Library), while unix usually calls it SO (Shared Object). Mac OSX has yet another name (dylib or something). 2) .sql scrap is t

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

2012-06-12 Thread leaf_yxj
Hi John, Thanks for your quick reply. It's really help me a lot. 1) What's the info in .dll/.so ? 2) .sql scrap is the binary installation file? 3) For the same database, we need update C functions frequently ? Thanks. Regards. Grace At 2012-06-13 03:08:26,"John R Pierce [via Post

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

2012-06-12 Thread John R Pierce
On 06/12/12 12:07 PM, leaf_yxj wrote: one more question: so it's one time jobs or it need keep doing. each time the C function is updated, you would need to DROP FUNCTION / replace binary / CREATE FUNCTION in any database that needs it. and each time you create a new database that needs it,

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

2012-06-12 Thread leaf_yxj
Hi John, one more question: so it's one time jobs or it need keep doing. Thanks. Grace At 2012-06-13 02:48:20,"John R Pierce [via PostgreSQL]" wrote: On 06/12/12 11:25 AM, leaf_yxj wrote: > Thanks. You guys are right. I check the database. The C programm is > there. - but why our

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

2012-06-12 Thread John R Pierce
On 06/12/12 12:04 PM, leaf_yxj wrote: So can I ( the superuser) do it by myself and how can I do it? the devs would give you the .dll/.so file, and a .sql scrap to do the install. you'd put the .so/.dll in an appropriate place, and run the .sql scrap to install it into a given database.

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

2012-06-12 Thread leaf_yxj
John, So can I ( the superuser) do it by myself and how can I do it? Thanks. Grace At 2012-06-13 02:48:20,"John R Pierce [via PostgreSQL]" wrote: On 06/12/12 11:25 AM, leaf_yxj wrote: > Thanks. You guys are right. I check the database. The C programm is > there. - but why our appl

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

2012-06-12 Thread John R Pierce
On 06/12/12 11:25 AM, leaf_yxj wrote: 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

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

2012-06-12 Thread leaf_yxj
Hi Tom, 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.

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

2012-06-12 Thread leaf_yxj
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. Reg

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

2012-06-12 Thread leaf_yxj
Hi Raymond, 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.

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

2012-06-12 Thread yxj
Hi Tom, 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. Regar

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

2012-06-12 Thread John R Pierce
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) RETU

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

2012-06-12 Thread Tom Lane
leaf_yxj writes: > I need to create c language in the postgresql database. Why do you think you need to do that? It's built-in. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.pos

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

2012-06-12 Thread Raymond O'Donnell
On 12/06/2012 17:53, leaf_yxj wrote: > I need to create c language in the postgresql database. I only know > to create as follows. > > Create language c ; > > > Is there anything else I need to do before I create the C language? Hello Grace, C isn't available (AFAIK) as a procedural language;