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

Re: Triggers, Rules and email

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Paul <pauljw(at)truswan(dot)com>
Cc: <pgsql-php(at)postgresql(dot)org>
Subject: Re: Triggers, Rules and email
Date: 2004-01-20 17:59:05
Message-ID: Pine.LNX.4.33.0401201057460.15639-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: pgsql-php
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


In response to

Responses

pgsql-php by date

Next:From: Michael StoyanovichDate: 2004-01-20 19:56:47
Subject: Combine/trim records
Previous:From: PaulDate: 2004-01-20 17:06:39
Subject: Triggers, Rules and email

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