This 'feature' makes such a view unusable in the clients (MS Access or any
other ADO based) that *do verify* update count and report an error if it is
not of expected value.
Is there a workaround for this?
Peter, you mentioned it is documented, may you please point me to the
document you meant?
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Eugene M. Hutorny" <eugene@ksf.kiev.ua>
Cc: <pgsql-bugs@postgresql.org>
Sent: Tuesday, November 20, 2007 8:28 PM
Subject: Re: [BUGS] BUG #3764: Update count returns zero for a view with 'on
update' rules when criteria contains updatable field
"Eugene M. Hutorny" <eugene@ksf.kiev.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
----- Original Message -----
From: "Peter Eisentraut" <peter_e@gmx.net>
To: <pgsql-bugs@postgresql.org>
Cc: "Eugene M. Hutorny" <eugene@ksf.kiev.ua>
Sent: Tuesday, November 20, 2007 7:58 PM
Subject: Re: [BUGS] BUG #3764: Update count returns zero for a view with 'on
update' rules when criteria contains updatable field
Am Dienstag, 20. November 2007 schrieb Eugene M. Hutorny:
> Description: Update count returns zero for a view with 'on update'
> rules when criteria contains updatable field
This is known and documented.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/