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

Reply via email to