[Pypgsql-devel] [ pypgsql-Bugs-589370 ] PgSQL.py hangs on empty result

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

Bugs item #589370, was opened at 2002-07-31 23:03
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=116528&aid=589370&group_id=16528

Category: PgSQL
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: PgSQL.py hangs on empty result

Initial Comment:
PACKAGE:
pyPgSQL 2.1 (and in 2.0 too) Win32

USING:
python 2.2 (Win32)
Server 7.1.2 Mandrake Linux 8.1

ERROR:
PgSQL.py hangs on line 2142 on empty result.

SEE DETAILS IN ATTACHED FILE!

select 
b.Bitrate,b.DauerTxt,b.Dauer,b.OID,b.Artist,a.Name,a.OI
D,b.Track,b.Genre,       
a.PlayList,a.Kommentar,b.Jahr,b.ImportStamp,a.Item,b.
Album,a.Entry,b.Title,b.Filename
from PlayLists as a,AlleTitel as b
where a.Entry=b.OID and (a.PlayList=1 and a.Item>=0)
order by a.Item

###############################################
########
This results in the following error (Notice: There are the 
OIDs of both files selected!)

Traceback (most recent call last):
  File "jukebox.py", line 476, in ?
    main()
  File "jukebox.py", line 472, in main
    myApp = App()
  File "jukebox.py", line 27, in __init__
    wxApp.__init__(self,0)
  File "C:\Programme\python22\lib\site-
packages\wxPython\wx.py", line 1587, in __init__
    _wxStart(self.OnInit)
  File "jukebox.py", line 38, in OnInit
    self.readPlaylist()
  File "jukebox.py", line 296, in readPlaylist
    self.tbPtitles.readTitles(playlist)
  File "jukedb.py", line 271, in readTitles
    return self.readMore(where=wcls, order="a.Item")
  File "sqldb.py", line 228, in readMore
    cursor.execute(query)
  File "C:\PROGRA~1\Python22\Lib\site-
packages\pyPgSQL\PgSQL.py", line 2415, in execute
    self.__makedesc__()
  File "C:\PROGRA~1\Python22\Lib\site-
packages\pyPgSQL\PgSQL.py", line 2142, in 
__makedesc__
    _p = _res.getvalue(0, _i)
ValueError: result does not contain any tuples.


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

>Comment By: Gerhard Häring (ghaering)
Date: 2002-08-01 09:08

Message:
Logged In: YES 
user_id=163326

I can't reproduce the problem here with PostgreSQL 7.2.1,
but will try later with a 7.1.3 at home. It'd still be ueful
if you could upload your schema and code.

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

Comment By: Gerhard Häring (ghaering)
Date: 2002-08-01 08:55

Message:
Logged In: YES 
user_id=163326

Thanks for your submission. Your attachment wasn't uploaded. Most
probably you forgot to activate the checkbox titled "Check to
Upload and Attach a File".

This is a Sourceforge annoyance that we can do nothing about.
Would you please upload your file again? Thanks.

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

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