Re: select count(*) - Mailing list pgsql-odbc

From Karol Szkudlarek
Subject Re: select count(*)
Date
Msg-id 411A0755.10800@mikronika.com.pl
Whole thread Raw
In response to Re: select count(*)  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: select count(*)
List pgsql-odbc
Peter Eisentraut wrote:

>Karol Szkudlarek wrote:
>
>
>>Hi!
>>
>>After compiling and installing cvs-tree psqlodbc driver I can't
>>do:
>>*) select count(*) from tablename.
>>
>>where tablename is any table name;
>>
>>Beacuse it returns error:
>>MSG= The cursor is open.;
>>Unrecognized key passed to SQLGetInfo30.
>>ERR=3
>>SQLSTATE=HY010
>>
>>
>
>Works for me (tm):
>
>$ isql pgtest
>[...]
>SQL> select count(*) from pg_class;
>+---------------------+
>| count               |
>+---------------------+
>| 180                 |
>+---------------------+
>1 rows affected
>1 rows returned
>
>Is this possibly another 64-bit issue?  Are you still running on amd64?
>
>
>
Hi!

Also for me statement *) from isql works ok. But from my project it
doesn't.
Maybe I should prepare simple test case?

I got error on my home AMD 2000XP (32-bit) platform (amd64 I have at
work.. :-))
And I didn't tested *) with cvs-tree psqlodbc driver at work computer yet.

Greets, Karol




pgsql-odbc by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: select count(*)
Next
From: Peter Eisentraut
Date:
Subject: Re: select count(*)