X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CB0A5D7D62 for ; Sun, 20 Nov 2005 13:15:17 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09416-04 for ; Sun, 20 Nov 2005 17:15:16 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp-out1.blueyonder.co.uk (smtp-out1.blueyonder.co.uk [195.188.213.4]) by svr1.postgresql.org (Postfix) with ESMTP id 0652AD7A52 for ; Sun, 20 Nov 2005 13:15:14 -0400 (AST) Received: from Eve ([82.43.185.102]) by smtp-out1.blueyonder.co.uk with Microsoft SMTPSVC(5.0.2195.6713); Sun, 20 Nov 2005 17:16:08 +0000 Reply-To: From: Andy Ballingall To: "'Andreas Kretschmer'" , Subject: Re: Is it possible to redirect an update/insert/delete to a different table? Date: Sun, 20 Nov 2005 17:15:22 -0000 Organization: Areyoulocal Ltd. MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcXt8cIkpAxp8YhQSMa4ued2NE0T1wAAr7ow In-Reply-To: <20051120164234.GB2832@kaufbach.delug.de> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Message-ID: X-OriginalArrivalTime: 20 Nov 2005 17:16:08.0085 (UTC) FILETIME=[18A0B450:01C5EDF6] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/175 X-Sequence-Number: 23426 >Try it. [snipped example] Ah. Basically, you set up the rule to assign every column, and if the update doesn't redefine some columns, then it still works. I didn't understand that you could get the rule to work generically like this. I'll presume that the rule will need amending if the table column definition later changes. (E.g. if I add 'stalk_length' to my apples and pears tables)... Thanks very much for your help. Andy