PL/Python: No stack trace for an exception - Mailing list pgsql-hackers

From Sushant Sinha
Subject PL/Python: No stack trace for an exception
Date
Msg-id 1311254877.2302.4.camel@dragflick
Whole thread Raw
Responses Re: PL/Python: No stack trace for an exception
Re: PL/Python: No stack trace for an exception
List pgsql-hackers
I am using plpythonu on postgres 9.0.2. One of my python functions was
throwing a TypeError exception. However, I only see the exception in the
database and not the stack trace. It becomes difficult to debug if the
stack trace is absent in Python.

logdb=# select get_words(forminput) from fi;           
ERROR:  PL/Python: TypeError: an integer is required
CONTEXT:  PL/Python function "get_words"


And here is the error if I run that function on the same data in python:

Traceback (most recent call last): File "valid.py", line 215, in <module>   parse_query(result['forminput']) File
"valid.py",line 132, in parse_query   dateobj = datestr_to_obj(columnHash[column]) File "valid.py", line 37, in
datestr_to_obj  dateobj = datetime.date(words[2], words[1], words[0])
 
TypeError: an integer is required


Is this a known problem or this needs addressing?

Thanks,
Sushant.



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [v9.1] sepgsql - userspace access vector cache
Next
From: Peter Geoghegan
Date:
Subject: Re: PL/Python: No stack trace for an exception