pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedplpgsql functions to 'C' functions
4+ messages / 2 participants
[nested] [flat]
* plpgsql functions to 'C' functions
@ 2005-02-02 13:57 Peter Manchev <pmanchev@hotmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Peter Manchev @ 2005-02-02 13:57 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: plpgsql functions to 'C' functions
@ 2005-02-03 06:21 Michael Fuhr <mike@fuhr.org>
parent: Peter Manchev <pmanchev@hotmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Michael Fuhr @ 2005-02-03 06:21 UTC (permalink / raw)
To: Peter Manchev <pmanchev@hotmail.com>; +Cc: pgsql-sql
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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: plpgsql functions to 'C' functions
@ 2005-02-03 13:31 Peter Manchev <pmanchev@hotmail.com>
parent: Michael Fuhr <mike@fuhr.org>
0 siblings, 1 reply; 4+ messages in thread
From: Peter Manchev @ 2005-02-03 13:31 UTC (permalink / raw)
To: mike@fuhr.org; +Cc: 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@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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: plpgsql functions to 'C' functions
@ 2005-02-03 19:00 Michael Fuhr <mike@fuhr.org>
parent: Peter Manchev <pmanchev@hotmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Michael Fuhr @ 2005-02-03 19:00 UTC (permalink / raw)
To: Peter Manchev <pmanchev@hotmail.com>; +Cc: pgsql-sql
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/
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-02-03 19:00 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-02 13:57 plpgsql functions to 'C' functions Peter Manchev <pmanchev@hotmail.com>
2005-02-03 06:21 ` Michael Fuhr <mike@fuhr.org>
2005-02-03 13:31 ` Peter Manchev <pmanchev@hotmail.com>
2005-02-03 19:00 ` Michael Fuhr <mike@fuhr.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox