Re: select count(*)

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