X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 22EEFD1CC9B for ; Fri, 30 Jan 2004 16:00:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 86892-04 for ; Fri, 30 Jan 2004 12:00:08 -0400 (AST) Received: from mail.medifarma.com.pe (unknown [64.76.132.67]) by svr1.postgresql.org (Postfix) with ESMTP id 921E6D1CCAE for ; Fri, 30 Jan 2004 12:00:04 -0400 (AST) Received: from pegasus (FREE-USR-64.76.132.68.viaperu.com [64.76.132.68] (may be forged)) by mail.medifarma.com.pe (8.12.8/8.12.8) with SMTP id i0UFqTeM012365; Fri, 30 Jan 2004 10:52:29 -0500 Message-ID: <001a01c3e74a$33dca440$3d0000c0@pegasus> From: "Aldo Leyva Alvarado" To: "Robby Russell" , References: <401A7CF0.9020302@commandprompt.com> Subject: Re: Triggers, Rules and email Date: Fri, 30 Jan 2004 11:00:37 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/31 X-Sequence-Number: 2547 Yes, I want to see an example!!!!!! Aldo Leyva ----- Original Message ----- From: "Robby Russell" To: Sent: Friday, January 30, 2004 10:49 AM Subject: Re: [PHP] Triggers, Rules and email > 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@commandprompt.com | Telephone: (503) 667.4564 > #------------------------------------------------------- > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html