Hi, i tried pgagent as you suggested and it works well. I searched for another solution, because i wanted to reduce the maintenance work on the server (install, config autostart, etc.). The problem with triggers is, that i have a lot of points and the changes should be triggered to start the analysis. This has to be done everytime a point changes and takes some time. Thats why i thought to do it periodically.
Thanks for helping > If you don't mind doing it by event instead of time you can use a > database trigger. Example, for each new point the trigger happens and > adds the info you need. That way there is never a point without the > information. > > That's 100% in postgres as is. > > Enjoy, > Alex > > > On 04/05/2013 02:36 AM, Christian Röttger wrote: > > Thanks, > > > > i will give it a try. Maybe you have some good documentation for me, but > i > > will see what google has for me. > > > > So there is no build in solution, only the way of installing or > configuring > > additional packages, etc. which means "more" server maintenance ... > > > > > > 2013/4/4 Fred Lehodey > > <[email protected]<http://mc/[email protected]> > > > > > >> http://www.pgadmin.org/download/pgagent.php > >> > >> > >> > >> > >> On Thu, Apr 4, 2013 at 4:11 PM, Christian Röttger < > [email protected] <http://mc/[email protected]>>wrote: > >> > >>> Hi, > >>> > >>> sorry this question is more postgresql related, but maybe here is > >>> somebody with postgres skills :) I wrote a function which should be > >>> launched maybe every hour, or just once a night. Is there a > possibility to > >>> start this function directly in postgresql and not in a workaround > like a > >>> cronjob? > >>> > >>> The background is that i have some point and line tables and wrote a > >>> function which assigns the points in a specific distance to the lines. > >>> > >>> > >>> Greets > >>> Christian > >>> > >>> _______________________________________________ > >>> Qgis-user mailing list > >>> [email protected]<http://mc/[email protected]> > >>> http://lists.osgeo.org/mailman/listinfo/qgis-user > >>> > >>> > >> > > > > > > > > _______________________________________________ > > Qgis-user mailing list > > [email protected]<http://mc/[email protected]> > > http://lists.osgeo.org/mailman/listinfo/qgis-user > > > > _______________________________________________ > Qgis-user mailing list > [email protected] <http://mc/[email protected]> > http://lists.osgeo.org/mailman/listinfo/qgis-user > > > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user > >
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
