[Pypgsql-devel] pyPgSQL 2.5 datetime timezone issue

[Tim W. <twe...@ra...>]

Hi, 

After upgrading to pyPgSQL 2.5 (from 2.4) the returned DateTime objects returned from querying timestamp fields return different dates (for the same record).

2.4 result:
<DateTime object for '2006-05-29 08:09:11.00' at b7c85758>

2.5 result:
<DateTime object for '2006-05-29 17:39:11.00' at b7f91d08>

psql interactive result:
2006-05-29 08:09:11

Note that it adds exactly 9 hours and 30 minutes (I've tested this with various queries and it consistently does this). My timezone is +9:30. 

System details:
Fedora Core 3 Linux
postgresql-7.4.8-1.FC3.1
python-2.3.4-13.1

Is this a bug or are timezones handles differently in 2.5?

Regards, 
Tim