Re: Run procedure at startup - Mailing list pgsql-general

Hello

2009/7/27 Saleem EDAH-TALLY <nmset@netcourrier.com>:
> Hello,
>
> Is there a way to run a pl/pgsql automatically at server startup ?

no - only you can modify startup scripts

>
> Is there a way to run a pl/pgsql function with an infinite loop as a daemon
> ?

infinite loop is possible, but probably you need orafce or similar to
be infinite loop usable:

http://www.postgres.cz/index.php/Oracle_functionality_%28en%29#DBMS_ALERT
http://www.postgres.cz/index.php/Oracle_functionality_%28en%29#DBMS_PIPE

>
> Is there a way to start a pl/pgsql function that would persist after the
> user session has closed ?

yes - with some pooling sw like pgpool, bucardo and others

>
> Is there a way for an unprivileged user to delegate a task (allowed by
> superuser) to a superuser ?

yes - look on security definer flag
http://www.postgresql.org/docs/8.4/static/sql-createfunction.html

>
> Thanks in advance.
>
>

regards
Pavel Stehule