pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Otakar Kleps <kleps@avonet.cz>
To: pgsql-sql@postgresql.org
Cc: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Subject: Re: Help with RULE
Date: Fri, 16 Nov 2001 09:10:55 +0100
Message-ID: <3BF4CA0F.7020506@avonet.cz> (raw)
References: <20011115070711.Y7025-100000@megazone23.bigpanda.com>

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

Attachments:

example.sql (text/plain, 1.7K) download 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);

view thread (3+ messages)

Message-ID: <3BF4CA0F.7020506@avonet.cz>
Permalink:  ../3BF4CA0F.7020506@avonet.cz/
Also on:    postgresql.org/message-id/3BF4CA0F.7020506@avonet.cz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: kleps@avonet.cz, sszabo@megazone23.bigpanda.com
  Subject: Re: Help with RULE
  In-Reply-To: <3BF4CA0F.7020506@avonet.cz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox