on delete rules on a view problem - Mailing list pgsql-general

From Rose, Juergen
Subject on delete rules on a view problem
Date
Msg-id 1EDFE201921585419595B53913CAD6771B366E@exchange.cegit.de
Whole thread Raw
Responses Re: on delete rules on a view problem
List pgsql-general
Hi all,

I'am a bit puzzled. I have a view and some delete rules defined on it. Now my problem is, only one gets executed (the
firstone) and the other ones seem not to be executed at all. I use a subselect within those rules (which works fine for
thefirst one by the way) and I wonder if this could be a problem? Are there any caveats? Is it important which of
thesesrules is the do instead rule? 

Are there any things to be considered with using delete rules? I don't find any exhaustive documentation on the
internet(except pg manual), so any pointers will be appreciated. 

Many thanks
Jürgen

pgsql-general by date:

Previous
From: Roman Neuhauser
Date:
Subject: Re: Quotation marks in queries
Next
From: Dan Armbrust
Date:
Subject: Slow Inserts on 1 table?