[Pypgsql-devel] [ pypgsql-Patches-1583325 ] Incorrect handling of TIMESTAMP columns

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

Patches item #1583325, was opened at 2006-10-24 04:48
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=316528&aid=1583325&group_id=16528

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Dave Cole (davecole)
Assigned to: Nobody/Anonymous (nobody)
Summary: Incorrect handling of TIMESTAMP columns

Initial Comment:
The 2.5.1 module incorrectly applies the timezone
offset to TIMESTAMP columns.  I get correct results
querying TIMESTAMP columns using pqsl but pyPgSQL seems
to be double applying the timezone offset.

The attached patch Works For Me (TM) by only doing the
localtime() conversion for TIMESTAMP WITH TIME ZONE
columns.


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

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