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

From: leaf_yxj <leaf_yxj(at)163(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to create c language in postgresql database. Thanks.
Date: 2012-06-12 19:35:20
Message-ID: 7e2e2c7e.43b.137e2312357.Coremail.leaf_yxj@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 Library), while unix usually calls it SO (Shared
Object). Mac OSX has yet another name (dylib or something).

---- Grace comments : this need the superuser privileges on the server to copy those .so ( we are on the linux server) to the postgresql server ?
correct ????

> 2) .sql scrap is the binary installation file?

the .sql is the CREATE FUNCTION statement mostly.
--- Grace comments : we already grant create privileges on the saslib schema. So it means they can this scrap by themselves ???

> 3) For the same database, we need update C functions frequently ?

you tell me? how often do your programmers change them?
---- Grace commends : they tried to SAS to create lot of models. So I amn't sure about this issues. But John, thanks a lot for your answers.

Thanks.

Regards.

Grace

At 2012-06-13 03:27:45,"John R Pierce [via PostgreSQL]" <ml-node+s1045698n5712261h33(at)n5(dot)nabble(dot)com> wrote:
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 the binary installation file?

the .sql is the CREATE FUNCTION statement mostly.

> 3) For the same database, we need update C functions frequently ?

you tell me? how often do your programmers change them?

--
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-tp5712221p5712261.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-tp5712221p5712264.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philipp Kraus 2012-06-12 20:35:49 trigger on view returning created serial
Previous Message John R Pierce 2012-06-12 19:26:30 Re: How to create c language in postgresql database. Thanks.