I'm still seeing Horology failures on FreeBSD 4.9...

See attached diff.

Chris
Tue, 28 Oct 2003 11:34:44 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Horology failures

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, Pennsylvania 19073

Mon, 27 Oct 2003 22:40:52 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Horology failures
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
> 
> 


Tue, 28 Oct 2003 11:53:47 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: 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

Mon, 27 Oct 2003 23:16:34 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Horology failures 
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

Mon, 27 Oct 2003 23:52:50 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Horology failures 

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


Tue, 28 Oct 2003 01:09:03 -0500
"Andrew Dunstan" <andrew@dunslane.net>
Re: Horology failures 

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, Pennsylvania 19073

Tue, 28 Oct 2003 01:10:55 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Horology failures