On 2009-07-27, Saleem EDAH-TALLY <nmset@netcourrier.com> wrote:
> --Boundary-00=_NZcbKOfdE2cMluA
> Content-Type: text/plain;
> charset="us-ascii"
> Content-Transfer-Encoding: 7bit
>
> Hello,
>
> Is there a way to run a pl/pgsql automatically at server startup ?
pgagent perhaps? modify the startup scripts?
> Is there a way to run a pl/pgsql function with an infinite loop as a daemon ?
write a daemon (as a shell script if neccessary).
OTOH crontab or pgagent may be enough?
> Is there a way to start a pl/pgsql function that would persist after the user
> session has closed ?
pgagent perhaps?
> Is there a way for an unprivileged user to delegate a task (allowed by
> superuser) to a superuser ?
superuser specifys "security definer" when the superuser defines the
function.
><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;"><br></p>Is there a way to run a pl/pgsql automatically at server
startup?<br>
><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;"><br></p>Is there a way to run a pl/pgsql function with an
infiniteloop as a daemon ?<br>
><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;"><br></p>Is there a way to start a pl/pgsql function that would
persistafter the user session has closed ?<br>
><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;"><br></p>Is there a way for an unprivileged user to delegate a
task(allowed by superuser) to a superuser ?<br>
><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;"><br></p>Thanks in advance.<br>
><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0;text-indent:0px; -qt-user-state:0;"><br></p></body></html>
> --Boundary-00=_NZcbKOfdE2cMluA--
>