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" <[EMAIL PROTECTED]> To: "Eugene M. Hutorny" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> To: <pgsql-bugs@postgresql.org> Cc: "Eugene M. Hutorny" <[EMAIL PROTECTED]> 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/ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
