on delete rules on a view problem

From: "Rose, Juergen" <Juergen(dot)Rose(at)sag-el(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: on delete rules on a view problem
Date: 2005-07-20 14:49:26
Message-ID: 1EDFE201921585419595B53913CAD6771B366E@exchange.cegit.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 first one) and the other ones seem not to be executed at all. I use a subselect within those rules (which works fine for the first one by the way) and I wonder if this could be a problem? Are there any caveats? Is it important which of theses rules 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Armbrust 2005-07-20 14:50:54 Slow Inserts on 1 table?
Previous Message Roman Neuhauser 2005-07-20 14:05:55 Re: Quotation marks in queries