Thread: Horology failures

Horology failures

From
Christopher Kings-Lynne
Date:
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";

======================================================================


Re: Horology failures

From
Bruce Momjian
Date:
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@postgresql.org so that your
>       message can get through to the mailing list cleanly

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


Re: Horology failures

From
Christopher Kings-Lynne
Date:
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@postgresql.org so that your
>>      message can get through to the mailing list cleanly
> 
> 



Re: Horology failures

From
Tom Lane
Date:
Christopher Kings-Lynne <chriskl@familyhealth.com.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


Re: Horology failures

From
Tom Lane
Date:
I said:
> Christopher Kings-Lynne <chriskl@familyhealth.com.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


Re: Horology failures

From
"Andrew Dunstan"
Date:
er, plus 3 hours, I think, i.e. just under 2 hours from now ... (unless you
posted this in the future :-) )

[andrew@alphonso andrew]$ TZ=PST8PDT date
Mon Oct 27 22:07:22 PST 2003
[andrew@alphonso andrew]$ date
Tue Oct 28 01:07:28 EST 2003
[andrew@alphonso andrew]$


cheers

andrew

----- Original Message ----- 
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Cc: "Hackers" <pgsql-hackers@postgresql.org>
Sent: Monday, October 27, 2003 11:16 PM
Subject: Re: [HACKERS] Horology failures


> Christopher Kings-Lynne <chriskl@familyhealth.com.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



Re: Horology failures

From
Bruce Momjian
Date:
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@postgresql.org so that your
> >>      message can get through to the mailing list cleanly
> > 
> > 
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073