| Lists: | pgsql-hackers |
|---|
| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Horology failures |
| Date: | 2003-10-28 03:34:44 |
| Message-ID: | 3F9DE3D4.1050601@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
I'm still seeing Horology failures on FreeBSD 4.9...
See attached diff.
Chris
| Attachment | Content-Type | Size |
|---|---|---|
| regression.diffs | text/plain | 1.2 KB |
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Horology failures |
| Date: | 2003-10-28 03:40:52 |
| Message-ID: | 200310280340.h9S3eqs05050@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Time zone changes --- will be OK tomorrow.
---------------------------------------------------------------------------
Christopher Kings-Lynne wrote:
> I'm still seeing Horology failures on FreeBSD 4.9...
>
> See attached diff.
>
> Chris
>
> *** ./expected/horology.out Thu Sep 25 14:58:06 2003
> --- ./results/horology.out Tue Oct 28 11:29:24 2003
> ***************
> *** 577,583 ****
> SELECT (timestamp with time zone 'today' = (timestamp with time zone 'yesterday' + interval '1 day')) as "True";
> True
> ------
> ! t
> (1 row)
>
> SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
> --- 577,583 ----
> SELECT (timestamp with time zone 'today' = (timestamp with time zone 'yesterday' + interval '1 day')) as "True";
> True
> ------
> ! f
> (1 row)
>
> SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
> ***************
> *** 589,595 ****
> SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True";
> True
> ------
> ! t
> (1 row)
>
> SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
> --- 589,595 ----
> SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True";
> True
> ------
> ! f
> (1 row)
>
> SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
>
> ======================================================================
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Horology failures |
| Date: | 2003-10-28 03:53:47 |
| Message-ID: | 3F9DE84B.6070401@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
I thought you said that yesterday?
Chris
Bruce Momjian wrote:
> Time zone changes --- will be OK tomorrow.
>
> ---------------------------------------------------------------------------
>
> Christopher Kings-Lynne wrote:
>
>>I'm still seeing Horology failures on FreeBSD 4.9...
>>
>>See attached diff.
>>
>>Chris
>>
>
>
>>*** ./expected/horology.out Thu Sep 25 14:58:06 2003
>>--- ./results/horology.out Tue Oct 28 11:29:24 2003
>>***************
>>*** 577,583 ****
>> SELECT (timestamp with time zone 'today' = (timestamp with time zone 'yesterday' + interval '1 day')) as "True";
>> True
>> ------
>>! t
>> (1 row)
>>
>> SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
>>--- 577,583 ----
>> SELECT (timestamp with time zone 'today' = (timestamp with time zone 'yesterday' + interval '1 day')) as "True";
>> True
>> ------
>>! f
>> (1 row)
>>
>> SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
>>***************
>>*** 589,595 ****
>> SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True";
>> True
>> ------
>>! t
>> (1 row)
>>
>> SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
>>--- 589,595 ----
>> SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True";
>> True
>> ------
>>! f
>> (1 row)
>>
>> SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
>>
>>======================================================================
>>
>
>
>>---------------------------(end of broadcast)---------------------------
>>TIP 3: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>> message can get through to the mailing list cleanly
>
>
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Horology failures |
| Date: | 2003-10-28 04:16:34 |
| Message-ID: | 19286.1067314594@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
> I'm still seeing Horology failures on FreeBSD 4.9...
Should stop at midnight Tuesday, PST8PDT time (about 45 minutes
from now) ... see prior discussion ...
regards, tom lane
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Horology failures |
| Date: | 2003-10-28 04:52:50 |
| Message-ID: | 19464.1067316770@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
I said:
> Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
>> I'm still seeing Horology failures on FreeBSD 4.9...
> Should stop at midnight Tuesday, PST8PDT time (about 45 minutes
> from now) ... see prior discussion ...
Argh ... make that "3 hours from now" ... you'd think I could remember
the time shift between here and the Left Coast ...
regards, tom lane
| From: | "Andrew Dunstan" <andrew(at)dunslane(dot)net> |
|---|---|
| To: | "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Horology failures |
| Date: | 2003-10-28 06:09:03 |
| Message-ID: | 003f01c39d19$fce3da00$6401a8c0@DUNSLANE |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
er, plus 3 hours, I think, i.e. just under 2 hours from now ... (unless you
posted this in the future :-) )
[andrew(at)alphonso andrew]$ TZ=PST8PDT date
Mon Oct 27 22:07:22 PST 2003
[andrew(at)alphonso andrew]$ date
Tue Oct 28 01:07:28 EST 2003
[andrew(at)alphonso andrew]$
cheers
andrew
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Cc: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Sent: Monday, October 27, 2003 11:16 PM
Subject: Re: [HACKERS] Horology failures
> Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
> > I'm still seeing Horology failures on FreeBSD 4.9...
>
> Should stop at midnight Tuesday, PST8PDT time (about 45 minutes
> from now) ... see prior discussion ...
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Horology failures |
| Date: | 2003-10-28 06:10:55 |
| Message-ID: | 200310280610.h9S6AtB19844@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Oops, I have two words for you, "yesterday" and "tomorrow". ;-)
Seems the problem spans almost three days.
---------------------------------------------------------------------------
Christopher Kings-Lynne wrote:
> I thought you said that yesterday?
>
> Chris
>
> Bruce Momjian wrote:
>
> > Time zone changes --- will be OK tomorrow.
> >
> > ---------------------------------------------------------------------------
> >
> > Christopher Kings-Lynne wrote:
> >
> >>I'm still seeing Horology failures on FreeBSD 4.9...
> >>
> >>See attached diff.
> >>
> >>Chris
> >>
> >
> >
> >>*** ./expected/horology.out Thu Sep 25 14:58:06 2003
> >>--- ./results/horology.out Tue Oct 28 11:29:24 2003
> >>***************
> >>*** 577,583 ****
> >> SELECT (timestamp with time zone 'today' = (timestamp with time zone 'yesterday' + interval '1 day')) as "True";
> >> True
> >> ------
> >>! t
> >> (1 row)
> >>
> >> SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
> >>--- 577,583 ----
> >> SELECT (timestamp with time zone 'today' = (timestamp with time zone 'yesterday' + interval '1 day')) as "True";
> >> True
> >> ------
> >>! f
> >> (1 row)
> >>
> >> SELECT (timestamp with time zone 'today' = (timestamp with time zone 'tomorrow' - interval '1 day')) as "True";
> >>***************
> >>*** 589,595 ****
> >> SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True";
> >> True
> >> ------
> >>! t
> >> (1 row)
> >>
> >> SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
> >>--- 589,595 ----
> >> SELECT (timestamp with time zone 'tomorrow' = (timestamp with time zone 'yesterday' + interval '2 days')) as "True";
> >> True
> >> ------
> >>! f
> >> (1 row)
> >>
> >> SELECT (timestamp with time zone 'tomorrow' > 'now') as "True";
> >>
> >>======================================================================
> >>
> >
> >
> >>---------------------------(end of broadcast)---------------------------
> >>TIP 3: if posting/reading through Usenet, please send an appropriate
> >> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> >> message can get through to the mailing list cleanly
> >
> >
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073