Re: updatable views and optimistic locking

Tambet Matiisen wrote:
>
> Hi all!
>
> We are making a project management application which makes use of VB6
> bound controls and PostgreSQL updatable views. For several reasons we
> had to choose client side recordsets, which means we have to use
> optimistic locking scheme. Optimistic locking relies on number of
> affected records, returned by query. If affected record count is 0, then
> locking failed.
>
> The problem is, that when you define rules for views, all insert, update
> and delete statements return affected records 0, regardless if actual
> rule statement was successful or not. This of course screws up
> optimistic locking.

[snip]

> And my question is: who should I bother, to have this patch included in
> next PostgreSQL release? I consider it extremely useful, especially if
> you happen to use bound controls and updatable views.

Though my patch isn't applied, another patch to fix
the stupid bug is included in the next release.

regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/