Received: from eba-haus.de ([149.228.241.101]) by hub.org (8.9.3/8.9.3) with SMTP id DAA24347 for ; Mon, 17 Jan 2000 03:18:38 -0500 (EST) (envelope-from DieringG@eba-haus.de) Received: from kopo001 by eba-haus.de;Mon, 17 Jan 2000 08:13:06 GMT with Novell_GroupWise; Mon, 17 Jan 2000 09:13:07 +0100 Message-Id: X-Mailer: Novell GroupWise 5.5 Date: Mon, 17 Jan 2000 09:12:53 +0100 From: "Gerhard Dieringer" To: Cc: Subject: Antw: [SQL] attribute level rules not supported? Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id DAA24367 >>> Marc Tardif 16.01.2000 14.20 Uhr >>> > Here's the problem: > test=> CREATE TABLE a ( refb OID, at INT2 ); > test=> CREATE TABLE b ( refa OID, bt INT2 ); > test=> CREATE RULE ar AS ON UPDATE TO a.at > test-> DO UPDATE b SET b.bt = NEW.at > test-> WHERE refa = OLD.oid; > ERROR: attribute level rules currently not supported > What am I doing wrong? I've read and re-read chapter 8 - rules from the > postgresql programmer's guide, but I can't see why this rule doesn't work. > Any suggestions would be appreciated. > > Marc Try: CREATE RULE ar AS ON UPDATE TO a DO UPDATE b ..... I think you you should speciify the table a, not the attribute a.at. Gerhard