Re: Send email when new record inserted

#1

On Thu, 12 Feb 2004, Nick Tew wrote:

Quote:

This may seem a trivial task, but im stumped. When a new record is inserted
in one of my psql tables a need an email to be sent to pre-defined users.
The users will be 'interested parties' to the record inserted - therefore
these will be specified in a separate table. Is there a method for
completing this process?

You can do this either from a trigger (written in C or an untrusted pl
language) or with a listening application using the listen/notify
interface. The former has the problem that if the transaction is rolled
back, the email will already have been sent, but that may not be an issue
with your system. The latter is a bit more involved.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Send email when new record inserted

comp.databases.postgresql.novice comp.databases.postgresql.novice

Re: Send email when new record inserted - 02-15-2004 , 01:56 PM