Re: [GENERAL] change current user in pl/pgsql function

2006-02-06 Thread Bruno Wolff III
On Mon, Feb 06, 2006 at 15:43:30 +0300, Sergey Karin <[EMAIL PROTECTED]> 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

[GENERAL] change current user in pl/pgsql function

2006-02-06 Thread Sergey Karin
Hi, List!I use PG8.1Are 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