pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: silly sad <sad@bankir.ru>
To: pgsql-sql@postgresql.org
Subject: Re: Private functions
Date: Mon, 15 Mar 2010 09:25:21 +0300
Message-ID: <4B9DD2D1.1050004@bankir.ru> (raw)
In-Reply-To: <hnhkn1$7ks$2@reversiblemaps.ath.cx>
References: <4B9BD20B.9090601@gmail.com>
	<hnhkn1$7ks$2@reversiblemaps.ath.cx>

On 03/14/10 06:21, Jasen Betts wrote:
> On 2010-03-13, Gianvito Pio<pio.gianvito@gmail.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



view thread (4+ messages)

Message-ID: <4B9DD2D1.1050004@bankir.ru>
Permalink:  ../4B9DD2D1.1050004@bankir.ru/
Also on:    postgresql.org/message-id/4B9DD2D1.1050004@bankir.ru

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: sad@bankir.ru
  Subject: Re: Private functions
  In-Reply-To: <4B9DD2D1.1050004@bankir.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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