Re: PostgreSQL does not support updateable cursors - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: PostgreSQL does not support updateable cursors
Date
Msg-id 200802171621.36751.peter_e@gmx.net
Whole thread Raw
In response to PostgreSQL does not support updateable cursors  ("Premsun Choltanwanich" <Premsun@nsasia.co.th>)
List pgsql-sql
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/


pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Usage of UUID with 8.3 (Windows)
Next
From: Peter Eisentraut
Date:
Subject: Re: Backward compatibility psql 8.1 to 8.2