X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C582DD1E895 for ; Tue, 20 Jan 2004 17:07:51 +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 78839-01 for ; Tue, 20 Jan 2004 13:07:21 -0400 (AST) Received: from mail.truswan.com (mail.truswan.com [64.81.33.2]) by svr1.postgresql.org (Postfix) with ESMTP id 85C61D1E88E for ; Tue, 20 Jan 2004 13:07:09 -0400 (AST) Received: from truswan.com (0x503e3412.virnxx8.adsl-dhcp.tele.dk [80.62.52.18]) by mail.truswan.com (Postfix) with SMTP id 401371B4012 for ; Tue, 20 Jan 2004 08:52:42 -0800 (PST) Message-ID: <400D601F.5040606@truswan.com> Date: Tue, 20 Jan 2004 18:06:39 +0100 From: Paul User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: Triggers, Rules and email Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=USER_AGENT_MOZILLA_UA X-Spam-Level: X-Archive-Number: 200401/21 X-Sequence-Number: 2537 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? TIA, Paul