Received: from ns.infoset.cz (ns.infoset.cz [194.213.32.210]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA73908 for ; Wed, 13 Oct 1999 14:23:26 -0400 (EDT) (envelope-from dpeder@infoset.cz) Received: from WinProxy.anywhere ([62.168.15.178]) by ns.infoset.cz (8.8.7/8.8.7) with SMTP id UAA00560 for ; Wed, 13 Oct 1999 20:23:36 +0200 Received: from 192.168.1.1 by 192.168.1.3 (WinProxy); Wed, 13 Oct 1999 20:25:48 +0100 Received: by Dan with Microsoft Mail id <01BF15B8.B4FB5840@Dan>; Wed, 13 Oct 1999 20:22:44 +0100 Message-ID: <01BF15B8.B4FB5840@Dan> From: =?iso-8859-2?Q?Daniel_P=E9der?= To: "'pgsql-sql@postgresql.org'" Subject: big advance for replication - if the record could update itself using rules... Date: Wed, 13 Oct 1999 20:22:43 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit creating rule like such: mydb => create rule updtimeset as on update to mytab do update mytab set updtime = current_time ; causes this: mydb=> update mytab set updtime = current_time; ERROR: query rewritten 10 times, may contain cycles offcourse. however, it vould be great to have possibility to do something like that. Yes, i could use triggers, however such solution is not so clear as the rule-method could be... or do somebody know about ... ? -- dan peder dpeder@infoset.cz