Re: Triggers, Rules and email

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



scott.marlowe typed this on 01/20/2004 09:59 AM:
On Tue, 20 Jan 2004, Paul wrote:


Anyone know if I can create a trigger or a rule in Pgsql that will send an email in the event of an attempt to update a database field no-one should be updating?


Sure, that would involve installing the pl language of your choice as an untrusted language. PHP can be installed that way as a pl, btw, then you can just use the mail() trigger function in it.

http://www.commandprompt.com/entry.lxp?lxpe=294



Yes, plPHP can be used for this. If you want an example, let me know and I'll post one on the list.

-Robby

--
#-------------------------------------------------------
# Robby Russell,  |  Sr. Administrator / Lead Programmer
# Command Prompt, Inc.   |  http://www.commandprompt.com
# rrussell@xxxxxxxxxxxxxxxxx | Telephone: (503) 667.4564
#-------------------------------------------------------


[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux