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 EBB05DBC68 for ; Sat, 19 Nov 2005 20:26:58 -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 34865-04 for ; Sun, 20 Nov 2005 00:27:00 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp-out6.blueyonder.co.uk (smtp-out6.blueyonder.co.uk [195.188.213.9]) by svr1.postgresql.org (Postfix) with ESMTP id B4AFCDBC50 for ; Sat, 19 Nov 2005 20:26:54 -0400 (AST) Received: from Eve ([82.43.185.102]) by smtp-out6.blueyonder.co.uk with Microsoft SMTPSVC(5.0.2195.6713); Sun, 20 Nov 2005 00:27:51 +0000 Reply-To: From: Andy Ballingall To: Subject: Is it possible to redirect an update/insert/delete to a different table? Date: Sun, 20 Nov 2005 00:27:04 -0000 Organization: Areyoulocal Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0038_01C5ED69.21EC2400" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcXtaSHKo4dqIR2STTetnP1lML+ESg== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Message-ID: X-OriginalArrivalTime: 20 Nov 2005 00:27:51.0170 (UTC) FILETIME=[3DA80E20:01C5ED69] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[AWL=-0.001, HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200511/160 X-Sequence-Number: 23411 This is a multi-part message in MIME format. ------=_NextPart_000_0038_01C5ED69.21EC2400 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello, Is there a way that I can specify that a request to change to a particular table is redirected instead to a different table? I've looked through rules, and as far as I can make out, they are only useful for explicit actions. I'm looking for something that behaves as though it simply substitutes the table name for a different table name before executing the command, no matter what the command looks like. Thanks Andy Ballingall ------=_NextPart_000_0038_01C5ED69.21EC2400 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello,

 

Is there a way that I can specify that a request to = change to a particular table is redirected instead to a different = table?

 

I’ve looked through rules, and as far as I can = make out, they are only useful for explicit actions. I’m looking for = something that behaves as though it simply substitutes the table name for a = different table name before executing the command, no matter what the command = looks like.

 

Thanks

Andy Ballingall

------=_NextPart_000_0038_01C5ED69.21EC2400--