Received: from gate.avonet.cz (gate.avonet.cz [217.112.162.145]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAGB2Xm21721 for ; Fri, 16 Nov 2001 06:02:34 -0500 (EST) (envelope-from kleps@avonet.cz) Received: (from root@localhost) by gate.avonet.cz () id MAA19551 for pgsql-sql@postgresql.org; Fri, 16 Nov 2001 12:02:34 +0100 Received: from avonet.cz (ota.avonet.local [192.168.1.110]) by gate.avonet.cz () with ESMTP id MAA19500 for ; Fri, 16 Nov 2001 12:02:28 +0100 X-Authentication-Warning: gate.avonet.cz: Host ota.avonet.local [192.168.1.110] claimed to be avonet.cz Message-ID: <3BF4F15B.9070407@avonet.cz> Date: Fri, 16 Nov 2001 11:58:35 +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 Subject: Re: Help with RULE - my mistake References: <20011115070711.Y7025-100000@megazone23.bigpanda.com> <3BF4CA0F.7020506@avonet.cz> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200111/237 X-Sequence-Number: 5619 All is OK. Sorry (especially Tom Lane and Karel Zak). -- Otakar KLEPS AVONET, s.r.o. ----------------------------------------- tel./fax: 067/7217797 e-mail: kleps@avonet.cz http://www.avonet.cz http://www.zlin.cz Otakar Kleps wrote: > 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 >