Re: Help with RULE

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