Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group