Re: BUG #5268: PQgetvalue incorrectly returns 0

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, Jan 07, 2010 at 04:11:03AM +0000, Mike Landis wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5268
> Logged by: Mike Landis
> Email address: mlandis(at)pnmx(dot)com
> PostgreSQL version: 8.4.1
> Operating system: Vista
> Description: PQgetvalue incorrectly returns 0
> Details:
>
> When I execute the following SQL:
>
> "SELECT COUNT(*) FROM information_schema.tables WHERE table_name='proxies'"
>
> in the PGAdmmin 1.10.0, rev 7945-7946 query tool, I get "1" (the correct
> answer). When I run the exact same SQL in a C program, I get a result set
> with one tuple and one field (so far so good), but when I run
> PQgetvalue(resultSet,0,0) I get "0" (wrong answer).
>
> Am I missing something? You can't do squat in a client program without
> PQgetvalue(). Is any sort of regression test being run against libpq
> functions?

Hm. I don't know for sure, but I'd assume that PGAdmin relies on
libpq...

> What can I do to get this resolved?

Could you show us a more complete test case? That might help in
pin-pointing the problem.

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFLRYnoBcgs9XrR2kYRAjV/AJ9+HAZZu5sFKuHw1vp7aZNLKM7ykwCfQ+FX
q+NXaFojGP7uS4O/4Km/stM=
=zblK
-----END PGP SIGNATURE-----