Received: from faroenet.fo ([212.55.59.140]) by hub.org (8.10.1/8.10.1) with SMTP id e7IF1om02366 for ; Fri, 18 Aug 2000 11:01:56 -0400 (EDT) Received: (qmail 10971 invoked by uid 7719); 18 Aug 2000 16:05:57 -0000 Received: from unknown (HELO faroenet.fo) (192.168.1.21) by 192.168.1.1 with SMTP; 18 Aug 2000 16:05:57 -0000 Message-ID: <399D4FD0.11A258FB@faroenet.fo> Date: Fri, 18 Aug 2000 16:01:36 +0100 From: "Poul L. Christiansen" X-Mailer: Mozilla 4.71 [en] (WinNT; U) X-Accept-Language: en,pdf MIME-Version: 1.0 To: pgsql-sql Subject: update rule loops Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/176 Hi I'm trying to make a field in my table (datechanged) to automatically be updated with the value 'now()' when an update on the table occurs. plc=# create rule datechanged_radius AS ON update to radius do update radius set datechanged ='now()'; CREATE 22025360 1 plc=# update radius set destinationip = '212.055.059.001'; ERROR: query rewritten 10 times, may contain cycles This means that it's going in a loop, because the rule triggers itself. Is there another way to do this? Thanks, Poul L. Christiansen