4 replies to this topic

[mdexter]

First of all, to use views your PostGres tables must be defined with OID's. This used to be the default in the create table but I think it might not be with V8. Second, your view must then include the columns OID and CTID from one of the tables referenced in the view (normally the "primary" table in the view, so that they will be unique for each row of the view).

For some reason, when PRO-IV creates a cursor for Postgres it requires these columns to be present. Since all PRO-IV access to SQL tables is via a cursor, these columns must be present in any view accessed by PRO-IV. I don't know whether this is because of the way the ODBC driver works or is something from PRO-IV. If you look at the PostGres trace, you will see two SQL commands to find the row -- the second one uses CTID or OID or both (don't remember the details).

Also, if you want the view to be updateable, in addition to the normal rules for updateable views, you need to create Rules in Postgres -- one for UPDATE, one for DELETE, and one for INSERT. You can look in the Postgres documentation for details on this. These rules then allow PRO-IV to treat views as tables, including writing back to the views.

Hope this helps. Mark Dexter