View's rule on delete problem - Mailing list pgsql-general

From Stanislaw Tristan
Subject View's rule on delete problem
Date
Msg-id clpi03$2hvm$1@news.hub.org
Whole thread Raw
Responses Re: View's rule on delete problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: View's rule on delete problem  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
CREATE RULE "new_rule2" AS ON DELETE TO "public"."klients_view" 
DO INSTEAD (

DELETE
FROM klients
WHERE (klients.klient_id = old.klient_id);

DELETE
FROM klient_services
WHERE (klient_services.klient_id = old.klient_id);
);

It's 2 commands, but executing only first. Why?
 
Stanislaw Tristan
Kyiv, Ukraine
E-mail: stas7775@i.com.ua

pgsql-general by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: Reasoning behind process instead of thread based
Next
From: Andy Gimblett
Date:
Subject: Interpolation of environment variables in SQL at runtime?