Re: Error when changing views

Balt van Rees wrote:

> Hi,
>
> I have a problem with changing views in Access. Of course
> I designed the proper rules (CREATE RULE upd_viewfoo AS ON
> UPDATE TO viewfoo DO INSTEAD UPDATE tablebar SET ..... )
> and it all works when I update the view manually (i.e. in
> a terminal).

> However, when I try to update the view via ODBC (in Access
> 97) something goes wrong. Access gives me a basic error
> ("This record has been changed by another user, blablabla")
> that doesn't make sense in my opinion. What does make sense,
> however, is the my.log: among all the lines of code, I found
> the following:

[snip]

> IMHO, it seems the "UPDATE 0" returned by postgresql (as it also
> does on a manual update, since this is default when updating a
> view) makes the ODBC driver think 0 rows are updated, the query
> would be unsuccesfull and triggers the ROLLBACK and gives me the
> error in Access.

Yes. It's a known bug in 7.2. Please look at the thread
in pgsql-general [Using views and MS access via odbc]
e.g. http://archives.postgresql.org/pgsql-general/2002-05/msg00170.php.

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