Thread: plpgsql functions to 'C' functions

I would like to convert all my plpgsql functions to their 'C' equivalent 
coded functions.

Does anyone have experience in this matter?

Thank you,
Peter

On Wed, Feb 02, 2005 at 05:57:10AM -0800, Peter Manchev wrote:

> I would like to convert all my plpgsql functions to their 'C' equivalent 
> coded functions.

Why?  What problem are you trying to solve?

> Does anyone have experience in this matter?

See "C-Language Functions" in the documentation:

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

If you're having a specific difficulty then please show the code
you're using, explain what you want it to do, and describe what
acutally happens.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

On Thu, Feb 03, 2005 at 05:31:47AM -0800, Peter Manchev wrote:

> I believe the functionality I need (hiding the function code from users) 

Why do you want to hide the function code?  Does it contain sensitive
data?  As I asked before, what problem are you trying to solve?

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

I believe the functionality I need (hiding the function code from users) 
will be provided with the implementation of the the following item from the 
Postgresql todo list:

SERVER-SIDE LANGUAGES
-- Add Oracle-style packages

May be another future functionality will also help out, especially if the 
permission system can hide all objects but the function signatures from 
non-authorized:
-- Set proper permissions on non-system schemas during db creation

Until then, I have to figure out a way to implement it with the resources 
available... like (hand) re-coding the plpgsql functions to 'C' functions :/ 
Here is where I'd like to get your expert opinions (thank you very much in 
advance for all your efforts), so I can get started fast.

Thanks,
Peter


>From: Michael Fuhr <mike@fuhr.org>
>To: Peter Manchev <pmanchev@hotmail.com>
>CC: pgsql-sql@postgresql.org
>Subject: Re: [SQL] plpgsql functions to 'C' functions
>Date: Wed, 2 Feb 2005 23:21:07 -0700
...
>On Wed, Feb 02, 2005 at 05:57:10AM -0800, Peter Manchev wrote:
>
> > I would like to convert all my plpgsql functions to their 'C' equivalent
> > coded functions.
>
>Why?  What problem are you trying to solve?
>
> > Does anyone have experience in this matter?
>
>See "C-Language Functions" in the documentation:
>
>http://www.postgresql.org/docs/8.0/static/xfunc-c.html
>
>If you're having a specific difficulty then please show the code
>you're using, explain what you want it to do, and describe what
>acutally happens.
>
>--
>Michael Fuhr
>http://www.fuhr.org/~mfuhr/