bug in delete rule ?

From: sferriol <sylvain(dot)ferriol(at)imag(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: bug in delete rule ?
Date: 2004-03-25 15:29:48
Message-ID: 4062FAEC.60005@imag.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello
i have a view which joins two tables
CREATE VIEW ALL_CENTERS AS
SELECT
t0.center_id,
t0.institution,
t0.category,
t0.street_number,
t0.street_name,
t0.postcode,
t0.district_name,
t0.city_name,
t0.province_name,
t0.country,
t1.update_date,
t1.number_of_beds,
t1.chief,
t1.phone_center,
t1.fax_center
FROM
center t0,
center_var t1
WHERE
t0.center_id = t1.center_id;

and i create a rule for deleting using the view:
CREATE RULE ALL_CENTERS_DEL AS ON DELETE TO all_centers
DO INSTEAD (
DELETE FROM center_var WHERE
center_id = OLD.center_id;
DELETE FROM center WHERE
center_id = OLD.center_id;
);

but i this rule delete only line in center_var
and do not remove the line in center table

why ?

sylvain

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-03-25 15:37:30 Re: conversion_create.sql (Related to BUG#1072)
Previous Message Shawn Harrison 2004-03-25 15:20:07 Re: self referencing tables/ nested sets etc...