Received: from megazone.bigpanda.com ([63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAFF7hm16132 for ; Thu, 15 Nov 2001 10:07:43 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 465D8D5E6; Thu, 15 Nov 2001 07:07:47 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 3C0F25BE4; Thu, 15 Nov 2001 07:07:47 -0800 (PST) Date: Thu, 15 Nov 2001 07:07:47 -0800 (PST) From: Stephan Szabo To: Otakar Kleps Cc: Subject: Re: Help with RULE In-Reply-To: <3BF0D9CA.7050807@avonet.cz> Message-ID: <20011115070711.Y7025-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200111/210 X-Sequence-Number: 5594 On Tue, 13 Nov 2001, Otakar Kleps wrote: > On Postgres 7.1.3(SUSE Linux 7.0 - 2.2.16) I have this problem: > > I have table, for example: > > CREATE TABLE tbl_test( > id INTEGERE PRIMARY KEY, > ... > _parent INTEGER REFERENCES tbl_test ON DELETE CASCADE, > ... > ) > > Next, I create rule for table tbl_test on event ON DELETE: > CREATE RULE rule_test AS ON DELETE TO tbl_test DO INSERT INTO ...; > > Why RULE doesn't DELETE recursive(for a consideration REFERANCES)!? I'm running 7.2b2 but I don't see that behavior, can you give a full test set?