Received: from moutvdom00.kundenserver.de (moutvdom00.kundenserver.de [195.20.224.149]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0C6xJp99758 for ; Fri, 12 Jan 2001 01:59:19 -0500 (EST) (envelope-from jomu@uni-paderborn.de) Received: from [195.20.224.219] (helo=mrvdom03.kundenserver.de) by moutvdom00.kundenserver.de with esmtp (Exim 2.12 #2) id 14GyB8-0006ll-00 for pgsql-sql@postgresql.org; Fri, 12 Jan 2001 07:59:14 +0100 Received: from p3ee1ece8.dip0.t-ipconnect.de ([62.225.236.232] helo=sunrise.intra-muehlencord.de) by mrvdom03.kundenserver.de with esmtp (Exim 2.12 #2) id 14GyB5-0002bK-00 for pgsql-sql@postgresql.org; Fri, 12 Jan 2001 07:59:11 +0100 Received: from intra-muehlencord.de (moonworld.intra-muehlencord.de [192.168.1.12]) by sunrise.intra-muehlencord.de (Postfix) with ESMTP id 8A5631324E for ; Fri, 12 Jan 2001 07:57:56 +0100 (CET) Message-ID: <3A5EAB4E.DF530384@intra-muehlencord.de> Date: Fri, 12 Jan 2001 07:59:26 +0100 From: Joern Muehlencord X-Mailer: Mozilla 4.76 [de] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql Subject: automated log-messages Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/114 X-Sequence-Number: 775 Hi, I am trying to implement an automated log-message system for my application. For example, if a new user is inserted to my table "auth", I want to create a log message like: "user [name] added to system". Is it possible to add this message with triggers or rules?! If so, can anyone give some examples? Thanx, Joern -- Linux is like a wigwam - no Windows, no Gates and Apache inside