pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Premsun Choltanwanich <Premsun@nsasia.co.th>
To: pgsql-sql@postgresql.org
Subject: PostgreSQL does not support updateable cursors
Date: Tue, 12 Feb 2008 13:33:51 +0700
Message-ID: <47B19FFE.C5F7.004C.0@nsasia.co.th> (raw)

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

view thread (2+ messages)  latest in thread

Message-ID: <47B19FFE.C5F7.004C.0@nsasia.co.th>
Permalink:  ../47B19FFE.C5F7.004C.0@nsasia.co.th/
Also on:    postgresql.org/message-id/47B19FFE.C5F7.004C.0@nsasia.co.th

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: Premsun@nsasia.co.th
  Subject: Re: PostgreSQL does not support updateable cursors
  In-Reply-To: <47B19FFE.C5F7.004C.0@nsasia.co.th>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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