Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSQL does not support updateable cursors

PostgreSQL does not support updateable cursors

From
"Premsun Choltanwanich"
Date:
Dear All,
 
     I got error message 'ERROR: column "ctid" does not exist; Error while executing the query'  when I try to query SELECT on my VIEW as 'rsSystem.Open "SELECT * FROM v_memocatlist ORDER BY memocategory", connSystem, adOpenStatic, adLockOptimistic'.
 
     I found some information on internet about the PostgreSQL does not support updateable cursors so I change my code to be read only cursors as  'rsSystem.Open "SELECT * FROM v_memocatlist ORDER BY memocategory", connSystem, adOpenForwardOnly, adLockReadOnly' then it work fine. However, I need to use this query for make data ready to be updated on some record.
 
     How can I fix this problem?
 
More Information about my system.
Database: PostgreSQL 8.3
ODBC: psqlODBC 08.03.0100
Language: MS Visual Basic 6.0
 
Regards,
Premsun

NETsolutions Asia Limited

+66 (2) 237 7247

NETsolutions Asia Limited

Attachment

Re: PostgreSQL does not support updateable cursors

From
Peter Eisentraut
Date:
Premsun Choltanwanich wrote:
>      I found some information on internet about the PostgreSQL does not
> support updateable cursors so I change my code to be read only cursors as
>  'rsSystem.Open "SELECT * FROM v_memocatlist ORDER BY memocategory",
> connSystem, adOpenForwardOnly, adLockReadOnly' then it work fine. However,
> I need to use this query for make data ready to be updated on some record. 
>      How can I fix this problem?

8.3 supports updatable cursors.  Try that.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/