On 21 July 2011 14:27, Sushant Sinha <sushant...@gmail.com> wrote: > 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?
Traceback information will be added to PL/Python errors in Postgres 9.1, due out in about September. -- Peter Geoghegan http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers