I'm using pgMail for this type of capability. Go to
http://sourceforge.net and search for pgMail
From: Nicholas Allen [mailto:Allen(dot)Nicholas(at)lycos(dot)co(dot)uk]
Sent: Thursday, May 22, 2003 8:42 AM
Subject: [NOVICE] How to send an email when data is inserted into a
I have a table which stores bugs which can be submitted by users of our
program. I would like a way that when a new bug is inserted an email is
to the developers informing them of this.
I tried using a python trigger function to execute sendmail and pipe
headers to it but the problem seems to be that the python functions are
interpretted in a restrictive environment and don't allow access to
resources (files /processes etc). When I execute the python function
of postgres it works fine but not when used as a trigger functions.
I know I can do it by writing a C function but I would rather not use C
possible in the case. Python would be easier to maintain.
Any ideas? Do I have to use C or is there a way to do this from pyhton?
Thanks in advance for any help,
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
pgsql-novice by date
|Next:||From: Julie May||Date: 2003-05-22 21:21:13|
|Subject: Unable to open PostgreSQL large object|
|Previous:||From: Steve Crawford||Date: 2003-05-22 18:15:22|
|Subject: Re: Unaccounted for disk use|