pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL does not support updateable cursors
2+ messages / 2 participants
[nested] [flat]
* PostgreSQL does not support updateable cursors
@ 2008-02-12 06:33 Premsun Choltanwanich <Premsun@nsasia.co.th>
2008-02-17 15:21 ` Re: PostgreSQL does not support updateable cursors Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 2+ messages in thread
From: Premsun Choltanwanich @ 2008-02-12 06:33 UTC (permalink / raw)
To: pgsql-sql
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
http://www.nsasia.co.th
Attachments:
IMAGE.jpg (image/jpg, 6.3K) download
view image
* Re: PostgreSQL does not support updateable cursors
2008-02-12 06:33 PostgreSQL does not support updateable cursors Premsun Choltanwanich <Premsun@nsasia.co.th>
@ 2008-02-17 15:21 ` Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2008-02-17 15:21 UTC (permalink / raw)
To: pgsql-sql; +Cc: Premsun Choltanwanich <Premsun@nsasia.co.th>
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/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-02-17 15:21 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-12 06:33 PostgreSQL does not support updateable cursors Premsun Choltanwanich <Premsun@nsasia.co.th>
2008-02-17 15:21 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox