From: | Karol Szkudlarek <karol(at)mikronika(dot)com(dot)pl> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: select count(*) |
Date: | 2004-08-11 11:47:33 |
Message-ID: | 411A0755.10800@mikronika.com.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2004-08-11 13:36:52 | Re: select count(*) |
Previous Message | Peter Eisentraut | 2004-08-11 06:48:57 | Re: select count(*) |