Received: from biology.nmsu.edu (biology.NMSU.Edu [128.123.5.72]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA67469 for ; Wed, 17 May 2000 09:52:10 -0400 (EDT) (envelope-from brook@biology.nmsu.edu) Received: (from brook@localhost) by biology.nmsu.edu (8.8.8/8.8.8) id HAA19867; Wed, 17 May 2000 07:52:02 -0600 (MDT) Date: Wed, 17 May 2000 07:52:02 -0600 (MDT) Message-Id: <200005171352.HAA19867@biology.nmsu.edu> X-Authentication-Warning: biology.nmsu.edu: brook set sender to brook@biology.nmsu.edu using -f From: Brook Milligan To: kyle@actarg.com CC: pgsql-sql@postgresql.org In-reply-to: <3921E506.82424CAF@actarg.com> (message from Kyle Bateman on Tue, 16 May 2000 18:17:10 -0600) Subject: Re: question on update/delete rules on views References: <3921E506.82424CAF@actarg.com> X-Archive-Number: 200005/25 create rule view_a_r_update as on update to view_a do instead update a set two = new.two; The problem is that your INSTEAD UPDATE rule is not constrained in any way; it DOES hit every row. Instead, do something like: create rule view_a_r_update as on update to view_a do instead update a set two = new.two where id = old.id; where id is a primary key in your table. Cheers, Brook