On Sun, Mar 2, 2008 at 11:06 PM, Premsun Choltanwanich <Premsun(at)nsasia(dot)co(dot)th>
> Dear All,
> Regarding to my conversation on mailing list as shown below, Is my
> problem related with any function on psqlODBC ? And, How can I fix it?
No, the problem is not with the ODBC driver. The problem is that views in
postgresql are static non-update-able by default. So if you try to update
and record in a view using a cursor or any other sql statement, you will get
This problem can be fixed if your view meets the following criteria:
1) your view is based on only one table
2) your create rules for your view that define how updates to the view are
to be handled/cascaded to the base table.
3) since postgresql rules can only handle update statements that affect only
one tuple at a time, your cursor must only be able to update one record at a
Richard Broersma Jr.
In response to
pgsql-odbc by date
|Next:||From: Son Osiris||Date: 2008-03-03 17:12:14|
|Subject: Symbol files|
|Previous:||From: Premsun Choltanwanich||Date: 2008-03-03 07:06:03|
|Subject: PostgreSQL does not support updateable cursors|