Rules not executed on child tables - Mailing list pgsql-bugs

From
Subject Rules not executed on child tables
Date
Msg-id 29F36C7C98AB09499B1A209D48EAA615B4EBB2D72D@mail2a.alliedtesting.com
Whole thread Raw
Responses Re: Rules not executed on child tables  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-bugs
Hi,

I noticed that when an action is executed on a parent table, rules for that=
 action that are defined on its child tables are ignored.

Example:

create table A (ind integer);
create table B () inherits (A);

CREATE OR REPLACE RULE B_delete_rule AS
    ON DELETE TO B DO INSTEAD NOTHING;

insert into B values(0);

delete from B;
-- Query returned successfully: 0 rows affected, 0 ms execution time.
-- This is what I expected

delete from A;
-- Query returned successfully: 1 row affected, 0 ms execution time.
-- This is NOT what I expected!

I am using PostgreSQL 8.4.1 on Windows XP Pro

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: BUG #5622: Query failed: server closed the connection unexpectedly
Next
From: "Jens Wilke"
Date:
Subject: BUG #5623: xml2 and uuid-ossp contribs fail to compile