Re: BUG #3764: Update count returns zero for a view with 'on update' rules when criteria contains updatable field

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eugene M(dot) Hutorny" <eugene(at)ksf(dot)kiev(dot)ua>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3764: Update count returns zero for a view with 'on update' rules when criteria contains updatable field
Date: 2007-11-20 18:28:43
Message-ID: 11346.1195583323@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Eugene M. Hutorny" <eugene(at)ksf(dot)kiev(dot)ua> writes:
> I noticed strange behaviour of update statements issued to a view with an
> 'on update' rule when the where criterion contains the field being updated.

This isn't a bug --- once the first update is performed, the visible
view contents change and so the second update finds no matching row.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Cade Cairns 2007-11-20 21:22:30 BUG #3765: strange results for bit string hex notation cast to bit
Previous Message Peter Eisentraut 2007-11-20 17:58:21 Re: BUG #3764: Update count returns zero for a view with 'on update' rules when criteria contains updatable field