From: | David Leppik <dleppik(at)vocalabs(dot)com> |
---|---|
To: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #4849: intermittent future timestamps |
Date: | 2009-06-10 18:17:43 |
Message-ID: | D01028B2-120E-4C0A-BD65-03266BC52C07@vocalabs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
My typo. Converting java.sql.Timestamp to java.util.Date was buggy on
my end.
David
On Jun 10, 2009, at 1:00 PM, Kevin Grittner wrote:
> David Leppik <dleppik(at)vocalabs(dot)com> wrote:
>> Never mind. Turns out the bug was in our own code (read: me,
>> personally, being stupid) to convert a java.sql.Timestamp to
>> java.sql.Date. Why it works at all in MySQL... I don't even want
>> to know.
>
> java.sql.Date or java.util.Date? (You don't show your imports, so
> it's impossible to tell from the code snippet.) If it's
> java.util.Date, I can't immediately see why your errors would be
> greater than one second. If it's java.sql.Date, you're probably in
> territory where the behavior is undefined, but it's hard to see where
> you would get the results you showed. Perhaps there's an opportunity
> for us to make the PostgreSQL JDBC driver behave more sanely in this
> circumstance?
>
>> Why is it we can spend weeks looking at a bug, and we can't find
>> it until we decide to blame it on someone else?
>
> It's probably a corollary to the tendency to see our own gaffs when
> reading the post coming back from the list much more clearly than they
> appeared before clicking "send". :-/
>
> -Kevin
--
David Leppik
VP of Software Development
Vocal Laboratories, Inc.
dleppik(at)vocalabs(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2009-06-10 21:05:49 | Re: to_timestamp error handling. |
Previous Message | Kevin Grittner | 2009-06-10 18:00:46 | Re: BUG #4849: intermittent future timestamps |