Re: [GENERAL] allowing users access to a trusted C function

[Jeff Davis]

Tom Lane wrote:

> Jeff Davis <[EMAIL PROTECTED]> writes:
> > I created (as a superuser) a set of C functions to handle boolean
> > arithmetic (has to do with simplifying search queries of mine). I would
> > like users to be able to access those functions somehow.
>
> If the functions are listed in pg_proc, anyone can call them.
>
>                         regards, tom lane

I should have mentioned this, but all my users have their own DB. I have
entries for the functions in pg_proc for template1 and postgres (DB of my
superuser), but they won't be recognized in other DBs.

Thanks,
    Jeff Davis