Skip site navigation (1) Skip section navigation (2)

Re: Triggers, Rules and email

From: Robby Russell <rrussell(at)commandprompt(dot)com>
To: pgsql-php(at)postgresql(dot)org
Subject: Re: Triggers, Rules and email
Date: 2004-01-30 15:49:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-php
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.

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


# Robby Russell,  |  Sr. Administrator / Lead Programmer
# Command Prompt, Inc.   |
# rrussell(at)commandprompt(dot)com | Telephone: (503) 667.4564

In response to


pgsql-php by date

Next:From: Aldo Leyva AlvaradoDate: 2004-01-30 16:00:37
Subject: Re: Triggers, Rules and email
Previous:From: jodiDate: 2004-01-30 03:10:56

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group