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