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

Re: Error when changing views

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Balt van Rees <vanrees-postgres(at)vvtp(dot)tudelft(dot)nl>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Error when changing views
Date: 2002-06-07 02:51:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
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:


> 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]

Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-06-07 05:32:53
Subject: Re: Double error messages
Previous:From: Hiroshi InoueDate: 2002-06-07 02:40:58
Subject: Re: int8 becames string in BDE :-(

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