Help with RULE

From: Otakar Kleps <kleps(at)avonet(dot)cz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Help with RULE
Date: 2001-11-13 08:28:58
Message-ID: 3BF0D9CA.7050807@avonet.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)avonet(dot)cz
http://www.avonet.cz http://www.zlin.cz

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Robert Sundstrm 2001-11-13 09:27:20 Re: SQL99
Previous Message Gurudutt 2001-11-13 05:45:43 Joins!!