Received: from pcr.ca (www.pcr.ca [207.139.158.13] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id NAA06162 for ; Sun, 16 Jan 2000 13:20:56 -0500 (EST) (envelope-from admin@wtbwts.com) Received: by pcr.ca (Postfix, from userid 1000) id B0B6C1FEC; Sun, 16 Jan 2000 13:20:03 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by pcr.ca (Postfix) with ESMTP id 8CDFA1F8C for ; Sun, 16 Jan 2000 13:20:03 +0000 (GMT) Date: Sun, 16 Jan 2000 13:20:03 +0000 (GMT) From: Marc Tardif X-Sender: admin@server.b0x.com To: pgsql-sql@postgresql.org Subject: attribute level rules not supported? Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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