From: | "Peter Manchev" <pmanchev(at)hotmail(dot)com> |
---|---|
To: | mike(at)fuhr(dot)org |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: plpgsql functions to 'C' functions |
Date: | 2005-02-03 13:31:47 |
Message-ID: | BAY101-F25DD989F3CBC0B72F5EE70C57F0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)fuhr(dot)org>
>To: Peter Manchev <pmanchev(at)hotmail(dot)com>
>CC: pgsql-sql(at)postgresql(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | pginfo | 2005-02-03 13:52:16 | Re: pg primary key bug? |
Previous Message | pginfo | 2005-02-03 12:53:01 | pg primary key bug? |