"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
pgsql-bugs by date
|Next:||From: Cade Cairns||Date: 2007-11-20 21:22:30|
|Subject: BUG #3765: strange results for bit string hex notation cast to bit|
|Previous:||From: Peter Eisentraut||Date: 2007-11-20 17:58:21|
|Subject: Re: BUG #3764: Update count returns zero for a view with 'on update' rules when criteria contains updatable field|