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
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... |