View's rule on delete problem

From: "Stanislaw Tristan" <stas7775(at)i(dot)com(dot)ua>
To: pgsql-general(at)postgresql(dot)org
Subject: View's rule on delete problem
Date: 2004-10-28 01:32:21
Message-ID: clpi03$2hvm$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)i(dot)com(dot)ua

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-28 01:34:03 Re: Creating schema copy
Previous Message Ed L. 2004-10-28 00:32:01 Replicating sequences