| From: | <depstein(at)alliedtesting(dot)com> |
|---|---|
| To: | <pgsql-bugs(at)postgresql(dot)org> |
| Cc: | <vshahov(at)alliedtesting(dot)com> |
| Subject: | Rules not executed on child tables |
| Date: | 2010-08-18 09:36:07 |
| Message-ID: | 29F36C7C98AB09499B1A209D48EAA615B4EBB2D72D@mail2a.alliedtesting.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jens Wilke | 2010-08-18 13:55:13 | BUG #5623: xml2 and uuid-ossp contribs fail to compile |
| Previous Message | Craig Ringer | 2010-08-18 02:55:33 | Re: BUG #5622: Query failed: server closed the connection unexpectedly |