Re: select count(*)

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?

--
Peter Eisentraut
http://developer.postgresql.org/~petere/