PostgreSQL does not support updateable cursors

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.stehule <at> gmail.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.co.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",

Re: PostgreSQL does not support updateable cursors

Symbol files

[ psqlodbc-Bugs-1010308 ] Updatability regression after 08020200

Bugs item #1010308, was opened at 2008-03-03 18:56
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010308&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Pedro Gimeno (pgimeno)
Assigned to: Nobody (None)
Summary: Updatability regression after 08020200

Initial Comment:
In version 08_02_0200, the following query was updatable:

SELECT tbl1.pk, tbl1.data FROM tbl1
 INNER JOIN tbl2 ON tbl1.fk = tbl2.pk
 ;

In public releases 08_02_0300 and above, that query is no longer updatable.

Incidentally, the same happens with this query:

SELECT tbl1.pk, tbl1.data FROM tbl1
 -- INNER JOIN tbl2 ON tbl1.fk = tbl2.pk
 ;

even if the join is commented out as denoted by the "--".

We need those kinds of queries (the first kind, not the commented out one) to be updatable because that way we
can restrict the query using fields from tbl2 by means of a WHERE clause. We've had to downgrade the version
to 08_02_0200.

----------------------------------------------------------------------

You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010308&group_id=1000125

--
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your Subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc

Re: Symbol files

Hi

Please use this. 
http://winpg.jp/~saito/psqlODBC/Prep_Release/debug/
Sorry,  it has not included in a release package.

Regards,
Hiroshi Saito

----- Original Message ----- 
From: Son Osiris 
To: pgsql-odbc <at> postgresql.org 
Sent: Tuesday, March 04, 2008 2:12 AM
Subject: [ODBC] Symbol files

Does anybody where I can download the Win32 symbol files (.PDB) for the ANSI ODBC drivers psqlodbc30a ?

Thanks.

Never miss a thing. Make Yahoo your homepage. 

--
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your Subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc

Re: Symbol files

Build and other trouble with 08.03.0100 on Linux

The build process of psqlodbc 08.03.0100 on Linux (or Unix platforms) seems to 
have some open ends.  The default build uses SSL but doesn't link against any 
SSL library.  Not sure how relevant that is.  But I tried disabling the SSL 
support using the advertised option --disable-openssl, which doesn't work 
because the actual option is --disable-usessl.  (Side note: If you want to 
fix the option name, it might be nice to use --without-openssl to be 
consistent with PostgreSQL.)  That build then fails because NOT_USE_LIBPQ 
must be defined.  With a successful build I experience various kinds of 
problems building up a connection, some of which even go away for a while 
when I try to connect a few times (!!!).  The driver version 08.01.0200 I 
have lying around works without problems on the identical configuration 
(odbcinst.init and odbc.ini).  Is anyone successfully using psqlodbc 
08.03.0100 on Unix platforms?

--
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your Subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc

Re: Build and other trouble with 08.03.0100 on Linux

I've not been successfull with either 08.02.0500 or 08.03.0100. I posted 
my errors to this list last week. I think we may be experiencing the 
same problem. I'm building on Solaris though. 08.01.0200 works fine for 
me too.

Peter Eisentraut wrote:
> The build process of psqlodbc 08.03.0100 on Linux (or Unix platforms) seems to 
> have some open ends.  The default build uses SSL but doesn't link against any 
> SSL library.  Not sure how relevant that is.  But I tried disabling the SSL 
> support using the advertised option --disable-openssl, which doesn't work 
> because the actual option is --disable-usessl.  (Side note: If you want to 
> fix the option name, it might be nice to use --without-openssl to be 
> consistent with PostgreSQL.)  That build then fails because NOT_USE_LIBPQ 
> must be defined.  With a successful build I experience various kinds of 
> problems building up a connection, some of which even go away for a while 
> when I try to connect a few times (!!!).  The driver version 08.01.0200 I 
> have lying around works without problems on the identical configuration 
> (odbcinst.init and odbc.ini).  Is anyone successfully using psqlodbc 
> 08.03.0100 on Unix platforms?
> 
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
> To make changes to your Subscription:
> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc
> 
> 

--

-- 
+-------------------------------------------------------+
| Bruce McAlister                          Blueface Ltd |
| <bruce.mcalister <at> blueface.ie>  http://www.blueface.ie |
+-------------------------------------------------------+

--
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your Subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc

Re: Build and other trouble with 08.03.0100 on Linux

Hi.

Sorry, very late reaction...
Fundamentally, the problem may be included by the reason a protocol differs from 08.01 system.
Then, Since we received two or more reports, we need investigate again. Therefore, I will investigate 
this problem. But, Since it has the now personal problem, there is no free time. Please give me 
postponement of time. Sorry....

Regards,
Hiroshi Saito

----- Original Message ----- 
From: "Bruce McAlister" <bruce.mcalister <at> blueface.ie>

> I've not been successfull with either 08.02.0500 or 08.03.0100. I posted 
> my errors to this list last week. I think we may be experiencing the 
> same problem. I'm building on Solaris though. 08.01.0200 works fine for 
> me too.
> 
> Peter Eisentraut wrote:
>> The build process of psqlodbc 08.03.0100 on Linux (or Unix platforms) seems to 
>> have some open ends.  The default build uses SSL but doesn't link against any 
>> SSL library.  Not sure how relevant that is.  But I tried disabling the SSL 
>> support using the advertised option --disable-openssl, which doesn't work 
>> because the actual option is --disable-usessl.  (Side note: If you want to 
>> fix the option name, it might be nice to use --without-openssl to be 
>> consistent with PostgreSQL.)  That build then fails because NOT_USE_LIBPQ 
>> must be defined.  With a successful build I experience various kinds of 
>> problems building up a connection, some of which even go away for a while 
>> when I try to connect a few times (!!!).  The driver version 08.01.0200 I 
>> have lying around works without problems on the identical configuration 
>> (odbcinst.init and odbc.ini).  Is anyone successfully using psqlodbc 
>> 08.03.0100 on Unix platforms?
>> 
>> --
>> Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
>> To make changes to your Subscription:
>> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc
>> 
>> 
> 
> -- 
> +-------------------------------------------------------+
> | Bruce McAlister                          Blueface Ltd |
> | <bruce.mcalister <at> blueface.ie>  http://www.blueface.ie |
> +-------------------------------------------------------+
> 
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
> To make changes to your Subscription:
> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc

--
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your Subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc

Re: Build and other trouble with 08.03.0100 on Linux

Hi.

FreeBSD of the machine environment which I have does not reproduce a problem.

inet% psql -h localhost
Welcome to psql 8.2.6, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)

saito=# SELECT  ssl_is_used();
 ssl_is_used
-------------
 t
(1 row)

saito=# \q
inet% iodbctest DSN=PostgreSQL
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0406.0126
Driver: 08.03.0100 (psqlodbcw.so)

SQL>SELECT  ssl_is_used();

ssl_is_used
-----------
1

 result set 1 returned 1 rows.

SQL>

---

However, It may be that the difference between Linux and something happened the problem. 
Therefore, I want to see your log. If possible, please send a log to me. 

Regards,
Hiroshi Saito

----- Original Message ----- 
From: "Bruce McAlister" <bruce.mcalister <at> blueface.ie>

> I've not been successfull with either 08.02.0500 or 08.03.0100. I posted 
> my errors to this list last week. I think we may be experiencing the 
> same problem. I'm building on Solaris though. 08.01.0200 works fine for 
> me too.
> 
> Peter Eisentraut wrote:
>> The build process of psqlodbc 08.03.0100 on Linux (or Unix platforms) seems to 
>> have some open ends.  The default build uses SSL but doesn't link against any 
>> SSL library.  Not sure how relevant that is.  But I tried disabling the SSL 
>> support using the advertised option --disable-openssl, which doesn't work 
>> because the actual option is --disable-usessl.  (Side note: If you want to 
>> fix the option name, it might be nice to use --without-openssl to be 
>> consistent with PostgreSQL.)  That build then fails because NOT_USE_LIBPQ 
>> must be defined.  With a successful build I experience various kinds of 
>> problems building up a connection, some of which even go away for a while 
>> when I try to connect a few times (!!!).  The driver version 08.01.0200 I 
>> have lying around works without problems on the identical configuration 
>> (odbcinst.init and odbc.ini).  Is anyone successfully using psqlodbc 
>> 08.03.0100 on Unix platforms?
>> 
>> --
>> Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
>> To make changes to your Subscription:
>> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc

--
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc