Received: from desertmoon.com (qmailr@desertmoon.com [198.182.124.2]) by hub.org (8.9.2/8.9.1) with SMTP id JAA08167 for ; Thu, 11 Feb 1999 09:36:22 -0500 (EST) (envelope-from pierre@desertmoon.com) From: pierre@desertmoon.com Received: (qmail 29597 invoked by uid 100); 11 Feb 1999 14:42:46 -0000 Message-ID: <19990211144246.29596.qmail@desertmoon.com> Subject: [SQL] Rule problem (fwd) To: pgsql-sql@postgreSQL.org Date: Thu, 11 Feb 1999 07:42:46 -0700 (MST) X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit All, I never got any email concerning this issue. Has no one any ideas? > > All, > > > given this rule: > > create rule add_upref_os as on insert to upref_os do > update gen_stats set total = total + 1 where os_id=current.os_id; > > and this insert.... > > insert into upref_os values(1234,2); > > gives me this error continuously until I cancel the query: > > NOTICE: Non-functional update, only first update is performed > NOTICE: Non-functional update, only first update is performed > NOTICE: Non-functional update, only first update is performed > > I'm running 6.4. Any ideas? I've got other rules that seem to function without > issues... > > -=pierre > >