On Mon, Feb 06, 2006 at 15:43:30 +0300,
Sergey Karin <sergey.karin@gmail.com> wrote:
> Hi, List!
>
> I use PG8.1
>
> Are there any abilities to change current user during pl/pgsql function
> execution?
> I developed function that have 'security definer' option and created under
> superuser. But for executing some command in the function I need to change
> user to session_user and after execotion change user to superuser.
You can probably do what you want by having the top level function
run with the caller's security and have it call security definer functions
as necessary.