Skip site navigation (1) Skip section navigation (2)

Re: Bug #514: Backend crashes periodically

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Warren Volz <wrv(at)po(dot)cwru(dot)edu>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #514: Backend crashes periodically
Date: 2001-11-14 00:14:02
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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.

Hiroshi Inoue

In response to


pgsql-bugs by date

Next:From: Tom LaneDate: 2001-11-14 03:03:16
Subject: Re: Bug #514: Backend crashes periodically
Previous:From: Tom LaneDate: 2001-11-13 18:58:56
Subject: Re: Installation problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group