on delete rules on a view problem

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

on delete rules on a view problem

Rose, Juergen
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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [hidden email] so that your
       message can get through to the mailing list cleanly
Reply | Threaded
Open this post in threaded view
|

Re: on delete rules on a view problem

Bruno Wolff III
On Wed, Jul 20, 2005 at 16:49:26 +0200,
  "Rose, Juergen" <[hidden email]> wrote:
> 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.

I have seen similar reports in the past. In tht case the problem was that after
rows were removed from one table, the corresponding rows from the other table
could not be found because they were selected using a join and the rows
they were supposed to match up with were gone now.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster