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