Re: [GENERAL] bug in delete rule ?

[günter strubinsky]

Why don't you apply a cascading delete on center?

See bottom of
http://www.postgresql.org/docs/7.4/interactive/ddl-constraints.html :
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
...   shipping_address text,
     ...
 );
 
 CREATE TABLE order_items (
     product_no integer REFERENCES products ON DELETE RESTRICT,
     order_id integer REFERENCES orders ON DELETE CASCADE,
     quantity integer,
     PRIMARY KEY (product_no, order_id)
 );

Restricting and cascading deletes are the two most common options. RESTRICT
can also be written as NO ACTION and it's also the default if you do not
specify anything. There are two other options for what should happen...
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
with kind regards

 günter strubinsky
 <[EMAIL PROTECTED]>
 Tel: 402.212.0196
 

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of sferriol
Sent: Thursday, 25 March, 2004 09:30
To: [EMAIL PROTECTED]
Subject: [GENERAL] bug in delete rule ?

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



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend