Received: from gate.avonet.cz (gate.avonet.cz [217.112.162.145]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAG8Epm85132 for ; Fri, 16 Nov 2001 03:14:52 -0500 (EST) (envelope-from kleps@avonet.cz) Received: (from root@localhost) by gate.avonet.cz () id JAA18509; Fri, 16 Nov 2001 09:14:50 +0100 Received: from avonet.cz (ota.avonet.local [192.168.1.110]) by gate.avonet.cz () with ESMTP id JAA18428; Fri, 16 Nov 2001 09:14:47 +0100 X-Authentication-Warning: gate.avonet.cz: Host ota.avonet.local [192.168.1.110] claimed to be avonet.cz Message-ID: <3BF4CA0F.7020506@avonet.cz> Date: Fri, 16 Nov 2001 09:10:55 +0100 From: Otakar Kleps Organization: Avonet User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.5) Gecko/20011012 X-Accept-Language: en-us, cs MIME-Version: 1.0 To: pgsql-sql@postgresql.org CC: Stephan Szabo Subject: Re: Help with RULE References: <20011115070711.Y7025-100000@megazone23.bigpanda.com> Content-Type: multipart/mixed; boundary="------------070201080704090501010303" X-Archive-Number: 200111/235 X-Sequence-Number: 5617 This is a multi-part message in MIME format. --------------070201080704090501010303 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Stephan Szabo wrote: > 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? Example is in attachments. I try this example: a) works wrong on pg 7.1.3 on SUSE Linux 7.0 (SELECT version() => PostgreSQL 7.1.3 on i686-pc-linux-gnu,compiled by GCC 2.95.2) b) works OK!!! on pg 7.1.2 on Debian Linux 2.2.19 potato (SELECT version() => PostgreSQL on i686-pc-linux-gnu,compiled by GCC 2.95.2) c) works wrong on pg 7.1.3 on Debian Linux 2.2.20 potato (SELECT version() => PostgreSQL on i686-pc-linux-gnu,compiled by GCC 2.95.2) I don't uderstand (why this example works on Pg 7.1.2 and on Pg 7.1.3 not works)! Error is in configure param? Thanks PS: sorry form my english -- Otakar KLEPS AVONET, s.r.o. ----------------------------------------- tel./fax: 067/7217797 e-mail: kleps@avonet.cz http://www.avonet.cz http://www.zlin.cz --------------070201080704090501010303 Content-Type: text/plain; name="example.sql" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="example.sql" CREATE TABLE "a_tbl_tree" ( "id" integer NOT NULL, "_parent" integer, "_note" character varying(128), "_picture" character varying(255), Constraint "a_tbl_tree_pkey" Primary Key ("id") ); CREATE TABLE "a_tbl_log" ( "_time" timestamp with time zone DEFAULT "timestamp"('now'::text), "_picture" character varying(255) ); INSERT INTO "a_tbl_tree" ("id","_parent","_note","_picture") VALUES (0,0,'root',''); INSERT INTO "a_tbl_tree" ("id","_parent","_note","_picture") VALUES (1,0,'Master node 1','mn1.gif'); INSERT INTO "a_tbl_tree" ("id","_parent","_note","_picture") VALUES (2,0,'Master node 2','mn2.gif'); INSERT INTO "a_tbl_tree" ("id","_parent","_note","_picture") VALUES (3,0,'Master node 3','mn3.gif'); INSERT INTO "a_tbl_tree" ("id","_parent","_note","_picture") VALUES (10,1,'Sub-node 1-1','sn11.gif'); INSERT INTO "a_tbl_tree" ("id","_parent","_note","_picture") VALUES (11,1,'Sub-node 1-2','sn12.gif'); INSERT INTO "a_tbl_tree" ("id","_parent","_note","_picture") VALUES (12,1,'Sub-node 1-3','sn13.gif'); INSERT INTO "a_tbl_tree" ("id","_parent","_note","_picture") VALUES (13,1,'Sub-node 1-4','sn14.gif'); INSERT INTO "a_tbl_tree" ("id","_parent","_note","_picture") VALUES (20,2,'Sub-node 2-1','sn21.gif'); INSERT INTO "a_tbl_tree" ("id","_parent","_note","_picture") VALUES (21,2,'Sub-node 2-2','sn22.gif'); INSERT INTO "a_tbl_tree" ("id","_parent","_note","_picture") VALUES (22,2,'Sub-node 2-3','sn23.gif'); INSERT INTO "a_tbl_tree" ("id","_parent","_note","_picture") VALUES (33,3,'Sub-node 3-1','sn31.gif'); CREATE RULE rule_tbl_tree_del AS ON DELETE TO a_tbl_tree DO INSERT INTO a_tbl_log ("_picture") VALUES(OLD._picture); --------------070201080704090501010303--