Re: Send Email from Postgressql - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Send Email from Postgressql
Date
Msg-id 20070201191133.GA2724@wolff.to
Whole thread Raw
In response to Send Email from Postgressql  (brian stapel <brians_224@hotmail.com>)
List pgsql-novice
On Thu, Feb 01, 2007 at 08:54:34 -0600,
  brian stapel <brians_224@hotmail.com> wrote:
>
> I need to notify a user that data has changed.  To accomplish this I'd like to create a trigger that watches the
specifiedtable, that on change, sends the results returned by a function in the body of an email to a specific user.   

Yes this is possible to do with untrusted languages. For example you might
install perlu and write your function in that.

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: query efficiency - Can I speed it up?
Next
From: "Burak Seydioglu"
Date:
Subject: Is setQuerySnapshot called for embedded plpgsql function calls?