On 2009-07-27, Saleem EDAH-TALLY <nmset@xxxxxxxxxxxxxxx> 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 infinite loop 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 persist after 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-- > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
