X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2004F8B9B16 for ; Wed, 16 Feb 2005 20:56:03 +0000 (GMT) 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 50435-08 for ; Wed, 16 Feb 2005 20:55:42 +0000 (GMT) Received: from mail.99main.com (mail.99main.com [208.28.184.11]) by svr1.postgresql.org (Postfix) with ESMTP id BD8C88B9CE2 for ; Wed, 16 Feb 2005 20:49:01 +0000 (GMT) Received: from 99main.com (localhost [127.0.0.1]) by mail.99main.com (8.12.8+Sun/8.12.8) with ESMTP id j1GKmuwO002021; Wed, 16 Feb 2005 15:48:58 -0500 (EST) From: "Keith Worthington" To: pgsql-sql@postgresql.org Cc: "PFC" Reply-To: KeithW@narrowpathinc.com Subject: UPDATE TRIGGER on view WAS: Re: Relation in tables Date: Wed, 16 Feb 2005 15:48:56 -0500 Message-Id: <20050216204358.M29214@narrowpathinc.com> In-Reply-To: References: <20050216134301.5myrfpr3ck6bmswc@www.presserv.org> X-Mailer: Open WebMail 2.50 20050106 X-OriginatingIP: 68.235.22.242 (npkeithw) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/179 X-Sequence-Number: 20290 On Wed, 16 Feb 2005 19:56:25 +0100, PFC wrote > [snip] Use UPDATE triggers on the > views, which in fact write to the products table [snip] You can DO that!?! Are you saying that a client can DELETE or INSERT or UPDATE a view and through a trigger you can make this happen? Way cool. Can you provide a simple example? And all this time I thought that you couldn't write to a view. Kind Regards, Keith