[Zope] Zope/Postgres problem with change to CST

[Troy Farrell]

Hi Tim.  What did the SQL query look like before (ie CDT vs CST)?  Was 
the TZ format any different?

Troy

Tim Wilson wrote:
> Hi everyone,
> 
> I've built a small database application with Zope, PostgreSQL and
> ZPsycopgDA. Unfortunately, since we in the central time zone of the U.S.
> have switched from Daylight Saving Time to Standard Time, my app is now
> generating errors.
> 
> Here's a Z SQL method that illustrates the problem:
> 
> --snip--
> SELECT event.event_id, event_name, event_type, start_time, is_away,
> org_name, activity_name,
>        address, city
>   FROM event_participant, event, participant, location
>   WHERE
>     <dtml-sqltest expr="ZopeTime().earliestTime()"
> column="event.start_time" op="gt" type="string"> AND
>     <dtml-sqltest expr="ZopeTime().latestTime() + numdays"
> column="event.start_time" op="lt" type="string"> AND
>     <dtml-sqltest org_name column="participant.org_name" op="eq"
> type="string"> AND
>     event_participant.event_id = event.event_id AND
>     event_participant.participant_id = participant.participant_id AND
>     location.location_id = event.location_id
>   ORDER BY start_time
> --snip--
> 
> The following error is produced when this Z SQL method is called:
> 
> --snip--
> Error, psycopg.ProgrammingError: ERROR: Bad timestamp external
> representation '2002/11/01 23:59:59 US/Central' SELECT event.event_id,
> event_name, event_type, start_time, is_away, org_name, activity_name,
> address, city FROM event_participant, event, participant, location WHERE
> event.start_time > '2002/10/27' AND event.start_time < '2002/11/01
> 23:59:59 US/Central' AND participant.org_name = 'Henry Sibley High
> School' AND event_participant.event_id = event.event_id AND
> event_participant.participant_id = participant.participant_id AND
> location.location_id = event.location_id ORDER BY start_time 
> --------------------------------------------------------------------------------
> SQL used:
> 
> SELECT event.event_id, event_name, event_type, start_time, is_away,
> org_name, activity_name,
>        address, city
>   FROM event_participant, event, participant, location
>   WHERE
>     event.start_time > '2002/10/27' AND
>     event.start_time < '2002/11/01 23:59:59 US/Central' AND
>     participant.org_name = 'Henry Sibley High School' AND
>     event_participant.event_id = event.event_id AND
>     event_participant.participant_id = participant.participant_id AND
>     location.location_id = event.location_id
>   ORDER BY start_time
> --snip--
> 
> Anyone else seeing something like this? BTW, this is Zope 2.5.1, Python
> 2.1.3 on Debian Linux.
> 
> -Tim
>