Re: Bug #514: Backend crashes periodically

Tom Lane wrote:
>
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > BTW I have a question about this example.
> > Session 2 deletes no row because *session 1* already
> > deleted the rows but the session_del rule seems to
> > be invoked. Is it a right behavior ?
>
> Certainly the rule should be invoked --- whether it finds any rows
> cannot be determined until it's invoked, anyhow.  Remember a rule
> is not a trigger, it is a transform applied to the query before
> we begin execution.

Hmm I may have misunderstood your explanation.
What I meant is
  Session 2 invokes the session_del rule and really
  updates a sis_user row by the rule though it deletes
  no session row.

regards,
Hiroshi Inoue