[Gnumed-devel] time zones problem?

[Ian Haywood]

2004-04-26 18:28:08 [DATA]  
(/home/ian/gnumed/gnumed/Gnumed/wxpython/gmPatientHolder.py::_updateUI_wrapper:46):
 Traceback (most recent call last):<#10-0x0A-lf>
2004-04-26 18:28:08 [DATA]  
(/home/ian/gnumed/gnumed/Gnumed/wxpython/gmPatientHolder.py::_updateUI_wrapper:46):
   File "/home/ian/gnumed/gnumed/Gnumed/wxpython/gmPatientHolder.py", line 44, 
in _updateUI_wrapper<#10-0x0A-lf>    self._updateUI()<#10-0x0A-lf>
2004-04-26 18:28:08 [DATA]  
(/home/ian/gnumed/gnumed/Gnumed/wxpython/gmPatientHolder.py::_updateUI_wrapper:46):
   File "/home/ian/gnumed/gnumed/Gnumed/wxpython/gmDemographics.py", line 701, 
in _updateUI<#10-0x0A-lf>    dob = myPatient.getDOB()<#10-0x0A-lf>
2004-04-26 18:28:08 [DATA]  
(/home/ian/gnumed/gnumed/Gnumed/wxpython/gmPatientHolder.py::_updateUI_wrapper:46):
   File "/home/ian/gnumed/gnumed/Gnumed/business/gmDemographicRecord.py", line 
248, in getDOB<#10-0x0A-lf>    data = gmPG.run_ro_query('personalia', cmd, 
None, self.ID)<#10-0x0A-lf>
2004-04-26 18:28:08 [DATA]  
(/home/ian/gnumed/gnumed/Gnumed/wxpython/gmPatientHolder.py::_updateUI_wrapper:46):
   File "/home/ian/gnumed/gnumed/Gnumed/pycommon/gmPG.py", line 788, in 
run_ro_query<#10-0x0A-lf>    data = curs.fetchall()<#10-0x0A-lf>
2004-04-26 18:28:08 [DATA]  
(/home/ian/gnumed/gnumed/Gnumed/wxpython/gmPatientHolder.py::_updateUI_wrapper:46):
   File "/usr/lib/python2.3/site-packages/pyPgSQL/PgSQL.py", line 3208, in 
fetchall<#10-0x0A-lf>    _list.append(self.__fetchOneRow())<#10-0x0A-lf>
2004-04-26 18:28:08 [DATA]  
(/home/ian/gnumed/gnumed/Gnumed/wxpython/gmPatientHolder.py::_updateUI_wrapper:46):
   File "/usr/lib/python2.3/site-packages/pyPgSQL/PgSQL.py", line 2776, in 
__fetchOneRow<#10-0x0A-lf>    _r.getvalue(self._idx_, _i)))<#10-0x0A-lf>
2004-04-26 18:28:08 [DATA]  
(/home/ian/gnumed/gnumed/Gnumed/wxpython/gmPatientHolder.py::_updateUI_wrapper:46):
   File "/usr/lib/python2.3/site-packages/pyPgSQL/PgSQL.py", line 804, in 
typecast<#10-0x0A-lf>    return DateTime.ISO.ParseAny(value)<#10-0x0A-lf>
2004-04-26 18:28:08 [DATA]  
(/home/ian/gnumed/gnumed/Gnumed/wxpython/gmPatientHolder.py::_updateUI_wrapper:46):
   File "/usr/lib/python2.3/site-packages/mx/DateTime/ISO.py", line 313, in 
ParseAny<#10-0x0A-lf>    raise ValueError,'unsupported format:
"%s"' % isostring<#10-0x0A-lf>
2004-04-26 18:28:08 [DATA]  
(/home/ian/gnumed/gnumed/Gnumed/wxpython/gmPatientHolder.py::_updateUI_wrapper:46):
 ValueError: unsupported format: "1970-05-28 14:00:00+39600"<#10-0x0A-lf>


I can't seem to reproduce this from the Python console with the exact same 
query. I know mxDateTime doesn't support time zones, 
it seems to be choking on the "+39600", but why only inside gnumed?

I am using pypgsql 2.4.0-4 and postgresql 7.4.2-1 on Debian testing.

Ian

-- 
PGP public key E750652E at wwwkeys.pgp.net
9BF0 67B7 F84F F7EE 0C42  C063 28FC BC52 E750 652E

pgpxyZgrQ8l_B.pgp
Description: PGP signature