[SQL] Private functions

#1

Hi all,
is there a way to write a function that can only be called by another
function but not directly using SELECT function_name ( )?
Thanks

--
Sent via pgsql-sql mailing list (pgsql-sql (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

#2

Hello

directly no. There is only workaround - you can verify inside in
function content of pg_stat_activity_table - but this have to have a
superuser rights.

Regards
Pavel Stehule

2010/3/13 Gianvito Pio <pio.gianvito (AT) gmail (DOT) com>:

Quote:

Hi all,
is there a way to write a function that can only be called by another
function but not directly using SELECT function_name ( )?
Thanks

--
Sent via pgsql-sql mailing list (pgsql-sql (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

--
Sent via pgsql-sql mailing list (pgsql-sql (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

#3

On 2010-03-13, Gianvito Pio <pio.gianvito (AT) gmail (DOT) com> wrote:

Quote:

Hi all,
is there a way to write a function that can only be called by another
function but not directly using SELECT function_name ( )?

not really.

but there may be another way to get the effect you want.

--
Sent via pgsql-sql mailing list (pgsql-sql (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

#4

On 03/14/10 06:21, Jasen Betts wrote:

Quote:

On 2010-03-13, Gianvito Pio<pio.gianvito (AT) gmail (DOT) com> wrote:
Hi all,
is there a way to write a function that can only be called by another
function but not directly using SELECT function_name ( )?

not really.

but there may be another way to get the effect you want.

read the section SECURITY DEFINER
and GRANT and REVOKE and CREATE USER

--
Sent via pgsql-sql mailing list (pgsql-sql (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[SQL] Private functions

mailing.database.pgsql-sql mailing.database.pgsql-sql

[SQL] Private functions - 03-13-2010 , 11:57 AM

Re: [SQL] Private functions - 03-13-2010 , 12:00 PM

Re: [SQL] Private functions - 03-13-2010 , 09:21 PM

Re: [SQL] Private functions - 03-15-2010 , 12:25 AM