Received: from desertmoon.com (qmailr@desertmoon.com [198.182.124.2])
	by hub.org (8.9.2/8.9.1) with SMTP id QAA96932
	for <pgsql-sql@postgreSQL.org>; Wed, 10 Feb 1999 16:28:08 -0500 (EST)
	(envelope-from pierre@desertmoon.com)
From: pierre@desertmoon.com
Received: (qmail 4976 invoked by uid 100); 10 Feb 1999 21:34:28 -0000
Message-ID: <19990210213428.4975.qmail@desertmoon.com>
Subject: Rule problem
To: pgsql-sql@postgreSQL.org
Date: Wed, 10 Feb 1999 14:34:28 -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,


  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