Tom Lane wrote:
> Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)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.
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2001-11-14 03:03:16|
|Subject: Re: Bug #514: Backend crashes periodically |
|Previous:||From: Tom Lane||Date: 2001-11-13 18:58:56|
|Subject: Re: Installation problem |