From: | Otakar Kleps <kleps(at)avonet(dot)cz> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Help with RULE - my mistake |
Date: | 2001-11-16 10:58:35 |
Message-ID: | 3BF4F15B.9070407@avonet.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
All is OK.
Sorry (especially Tom Lane and Karel Zak).
--
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
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andriy Pyrozhenko | 2001-11-16 11:19:51 | SQL |
Previous Message | Andriy Pyrozhenko | 2001-11-16 09:38:30 | Question |