Re: PostgreSQL does not support updateable cursors

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Cc: "Premsun Choltanwanich" <Premsun(at)nsasia(dot)co(dot)th>
Subject: Re: PostgreSQL does not support updateable cursors
Date: 2008-02-17 15:21:36
Message-ID: 200802171621.36751.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2008-02-17 15:23:04 Re: Backward compatibility psql 8.1 to 8.2
Previous Message Peter Eisentraut 2008-02-17 15:20:40 Re: Usage of UUID with 8.3 (Windows)