Received: from gate.avonet.cz (gate.avonet.cz [217.112.162.145]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAD8Wom68082 for ; Tue, 13 Nov 2001 03:32:51 -0500 (EST) (envelope-from kleps@avonet.cz) Received: (from root@localhost) by gate.avonet.cz () id JAA07839 for pgsql-sql@postgresql.org; Tue, 13 Nov 2001 09:32:50 +0100 Received: from avonet.cz (ota.avonet.local [192.168.1.110]) by gate.avonet.cz () with ESMTP id JAA07706 for ; Tue, 13 Nov 2001 09:32:45 +0100 X-Authentication-Warning: gate.avonet.cz: Host ota.avonet.local [192.168.1.110] claimed to be avonet.cz Message-ID: <3BF0D9CA.7050807@avonet.cz> Date: Tue, 13 Nov 2001 09:28:58 +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: Help with RULE Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200111/199 X-Sequence-Number: 5583 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)!? Please HELP ME! Thank you -- Otakar KLEPS AVONET, s.r.o. ----------------------------------------- tel./fax: 067/7217797 e-mail: kleps@avonet.cz http://www.avonet.cz http://www.zlin.cz