[Pypgsql-devel] [ pypgsql-Bugs-625121 ] Error in corsur.rowcount

[<no...@so...>]

Bugs item #625121, was opened at 2002-10-18 09:47
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=116528&aid=625121&group_id=16528

Category: PgBoolean
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Alexander Meisel (alex)
Assigned to: Nobody/Anonymous (nobody)
Summary: Error in corsur.rowcount

Initial Comment:
Hi,

I'm using Redhat 7.2 on a alpha (not i386) with
PostgreSQL 7.2.3.
A simple query which actually succeeds gives a -1 back
on cursor.rowcount ... 

My test scipt looks like this:
---
#!/opt/bin/python2.2

from pyPgSQL import PgSQL

c = PgSQL.connect('user=alex dbname=kerneldb
host=localhost')
c1 = c.cursor()
c1.execute("SELECT * FROM project")
print c1.rowcount
data = c1.fetchall()
print data
---

The scripts output is:
---
[alex@wormhole alex]$ ./dbtest.py 
-1
[[1, 'linux', '']]
[alex@wormhole alex]$ 
---


I did run the test script in your source distributuion,
it had the following output:
---
bash-2.05$ python2.2 PgSQLTestCases.py 
.............F....................................................
======================================================================
FAIL: CheckBooleanConstructors
(__main__.PgSQLTestModuleInterface)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "PgSQLTestCases.py", line 167, in
CheckBooleanConstructors
    'PgBooleanFromInteger failed to create a FALSE
value (1).')
  File "/opt/lib/python2.2/unittest.py", line 258, in
failIf
    if expr: raise self.failureException, msg
AssertionError: PgBooleanFromInteger failed to create a
FALSE value (1).

----------------------------------------------------------------------
Ran 66 tests in 3.574s

FAILED (failures=1)
----

Hope you can fix it soon ... or I have to abandom my
lovely alpha and replace the db server with a horrible
intel machine. :-(

Thx in advance!

        Alex

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=116528&aid=625121&group_id=16528