Rules not executed on child tables

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-bugs by date

  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