From: | "Fontenot, Paul" <Paul(dot)Fontenot(at)bannerhealth(dot)com> |
---|---|
To: | "Nicholas Allen" <Allen(dot)Nicholas(at)lycos(dot)co(dot)uk> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: How to send an email when data is inserted into a table |
Date: | 2003-05-22 19:12:16 |
Message-ID: | 230BCAB977308F43BD851AFAE55A86413D6CD8@phx01018.bannerhealth.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I'm using pgMail for this type of capability. Go to
http://sourceforge.net and search for pgMail
-----Original Message-----
From: Nicholas Allen [mailto:Allen(dot)Nicholas(at)lycos(dot)co(dot)uk]
Sent: Thursday, May 22, 2003 8:42 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] How to send an email when data is inserted into a
table
Hi,
I have a table which stores bugs which can be submitted by users of our
client
program. I would like a way that when a new bug is inserted an email is
sent
to the developers informing them of this.
I tried using a python trigger function to execute sendmail and pipe
SMTP
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
local
resources (files /processes etc). When I execute the python function
outside
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
if
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,
Nicholas Allen.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Julie May | 2003-05-22 21:21:13 | Unable to open PostgreSQL large object |
Previous Message | Steve Crawford | 2003-05-22 18:15:22 | Re: Unaccounted for disk use |