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 87F92D82F0
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 18 Oct 2005 22:10:41 -0300 (ADT)
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 74614-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 19 Oct 2005 01:10:37 +0000 (GMT)
Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2])
	by svr1.postgresql.org (Postfix) with ESMTP id D46EED816C
	for <pgsql-sql@postgresql.org>; Tue, 18 Oct 2005 22:10:39 -0300 (ADT)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id 6610B31059; Wed, 19 Oct 2005 03:10:43 +0200 (MET DST)
From: Sarah Asmaels <sarah@spiesonline.net>
X-Newsgroups: pgsql.sql
Subject: writable joined view
Date: Wed, 19 Oct 2005 01:10:41 +0000 (UTC)
Organization: Aioe.org NNTP Server
Lines: 11
Message-ID: <dj17je$7vu$1@news.spiesonline.net>
X-Complaints-To: abuse@aioe.org
User-Agent: slrn/0.9.8.1pl1 (Linux)
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0 required=5 tests=[none]
X-Spam-Level: 
X-Archive-Number: 200510/265
X-Sequence-Number: 23118

Hi!

I have one table referencing an object in another table through an ID,
and a view joining those tables on the ID. I want to create rules to
rewrite updates/deletes/inserts on the joined view to act on the real
tables. Can you give me some pointers? The documentation has only
examples for views depending on single tables.

Thank you,

Sarah