Hi all,

    I have some doubts about SPI (Server Programming Interface). In fact, I must create Stored Procedures in Postgres (8.0). The problem is: all stored procedures and, may be, some triggers must be compiled 'cause the clients can't access the source code of them.
    To solve this problem, the solution that I was found is create the procedures (functions) in C with SPI to access the database.
    Now, the functions are writed in plgpsql. There are another ways to compile the code? If not, someone there are samples how can I use C with SPI?

Regards,
Danilo

> Hi all,
>
> I have some doubts about SPI (Server Programming Interface). In
> fact, I must create Stored Procedures in Postgres (8.0). The problem is:
> all stored procedures and, may be, some triggers must be compiled 'cause
> the clients can't access the source code of them.
> To solve this problem, the solution that I was found is create the
> procedures (functions) in C with SPI to access the database.
> Now, the functions are writed in plgpsql. There are another ways to
> compile the code? If not, someone there are samples how can I use C with
> SPI?

No, I'm not aware about any other way to obfuscate the source code. If
you are looking for some basic examples of procedures / functions
written in C, see this

http://www.postgresql.org/docs/8.1/i...e/xfunc-c.html
http://www.postgresql.org/docs/8.1/i...interface.html

But sure - that's just the basics.

Tomas

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster