Re: select count(*)

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: karol(at)mikronika(dot)com(dot)pl, pgsql-odbc(at)postgresql(dot)org
Subject: Re: select count(*)
Date: 2004-08-11 06:48:57
Message-ID: 200408110848.57505.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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/

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Karol Szkudlarek 2004-08-11 11:47:33 Re: select count(*)
Previous Message Karol Szkudlarek 2004-08-10 16:22:29 select count(*)