Re: Scheduled jobs

From: Kaare Rasmussen <kar(at)kakidata(dot)dk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Scheduled jobs
Date: 2003-05-13 15:04:52
Message-ID: 200305131704.52058.kar@kakidata.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)kakidata(dot)dk
2000 Frederiksberg Lørdag 12.00-16.00 Web: www.suse.dk

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2003-05-13 15:07:55 Re: Scheduled jobs
Previous Message Þórhallur Hálfdánarson 2003-05-13 14:48:11 Re: Scheduled jobs