From: | "Premsun Choltanwanich" <Premsun(at)nsasia(dot)co(dot)th> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | PostgreSQL does not support updateable cursors |
Date: | 2008-03-03 07:06:03 |
Message-ID: | 47CC056A.C5F7.004C.0@nsasia.co.th |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Dear All,
Regarding to my conversation on mailing list as shown below, Is my problem related with any function on psqlODBC ? And, How can I fix it?
Thank you,
Premsun
>>> "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> 2/12/2008 14:04 >>>
Hello
PostgreSQL support updateable cursors but doesn't support updateable
views - so you cannot update views via ADO recordset. You can update
only tables.
Regards
Pavel Stehule
On 12/02/2008, Premsun Choltanwanich <Premsun(at)nsasia(dot)co(dot)th> wrote:
>
>
> 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
+66 (2) 237 7247
http://www.nsasia.co.th
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma | 2008-03-03 14:31:36 | Re: PostgreSQL does not support updateable cursors |
Previous Message | Bruce McAlister | 2008-02-29 08:11:40 | Re: ODBC Version supporting specif databases? |