Re: Scheduled jobs - Mailing list pgsql-hackers

From Kaare Rasmussen
Subject Re: Scheduled jobs
Date
Msg-id 200305131704.52058.kar@kakidata.dk
Whole thread Raw
In response to Re: Scheduled jobs  (Zlatko Michailov <zmichailov@yahoo.com>)
List pgsql-hackers
> > That is, of course, quite separate from having cron in the core.  And
> > having a _good_ set of semantics for the push/pull is a nontrivial

Sometimes I need some external action to be taken when a table is updated. I
can't find anything about how to do this with triggers.

The easiest would be to have a server listening on a port. But can I write a
PL/pgSQL trigger that can talk tcp/ip?

There is a short description about untrusted Perl. This might solve the
problem of talking to the port, but I'm not sure I would like to run anything
called "Untrusted" in my server!

--
Kaare Rasmussen            --Linux, spil,--        Tlf:        3816 2582
Kaki Data                tshirts, merchandize      Fax:        3816 2501
Howitzvej 75               Åben 12.00-18.00        Email: kar@kakidata.dk
2000 Frederiksberg        Lørdag 12.00-16.00       Web:      www.suse.dk



pgsql-hackers by date:

Previous
From: Þórhallur Hálfdánarson
Date:
Subject: Re: Scheduled jobs
Next
From: Rod Taylor
Date:
Subject: Re: Scheduled jobs