Tom Lane wrote: > > Hiroshi Inoue <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
