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

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Cade CairnsDate: 2007-11-20 21:22:30
Subject: BUG #3765: strange results for bit string hex notation cast to bit
Previous:From: Peter EisentrautDate: 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

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