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 <[EMAIL PROTECTED]> To: Peter Manchev <[EMAIL PROTECTED]> 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/
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
