> 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/interactive/xfunc-c.html
http://www.postgresql.org/docs/8.1/interactive/trigger-interface.html
But sure - that's just the basics.
Tomas