Horton

Re: Re: v7.1.1 branched and released on Tuesday ...

Thomas Lockhart <lockhart@alumni.caltech.edu>

View thread
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: lockhart@fourpalms.org, Peter Eisentraut <peter_e@gmx.net>, The Hermit Hacker <scrappy@hub.org>, pgsql-hackers@postgresql.org
Date: 2001-04-30T17:58:54Z
Lists: pgsql-bugs, pgsql-hackers 
> Thomas, what do you think of the persistent reports of date conversion
> problems at DST boundaries, eg, Ayal Leibowitz's report today in
> pgsql-bugs?  I cannot reproduce any such problem --- and my local
> timezone database claims that MET DST transitions are the last week of
> March, never the first week of April, anyway.  There's something funny
> going on there.

Yes. I tried the example on 7.0.2 (and 7.1) and could not get it to
misbehave. I was guessing that it involves string->date conversion,
which may pass through timestamp to get there, but it looks like there
is an explicit text->date conversion function so time zone should just
never be involved. Really!

                   - Thomas