Re: a primer on trigger? - Mailing list pgsql-general

On Fri, May 04, 2001 at 12:48:24PM -0400, Joel Burton wrote:
> On Fri, 4 May 2001 newsreader@mediaone.net wrote:
>
> What is the system call? Could you do this in pl/tclu, the
> untrusted version of pl/tcl?
>

"system" call is a perl script which does many things
including the following

1. check the data for validity
2. write a text file
3. submit an "at" job with that text file
    as input.  The time that "at"
    job runs is also part of the
    incoming data in the email.
4. capture "at" job number
5. upload the data to postgres including
    "at" job number.

Sometime an email will come in to cancel
this "at" job.  In which case a different
perl script is called to look up "at"
job number and then calls "atrm" to kill
that job.