

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
> Sent: 28 October 2002 15:53
> To: Jason Tishler
> Cc: Dave Page; Bruce Momjian; PostgreSQL-development; Thomas 
> Lockhart; Pgsql-Cygwin
> Subject: Re: [HACKERS] Request for supported platforms 
> 
> 
> >> Make installcheck also failed on horology, copy2 and domain - see 
> >> attached output.
> >> 
> >> The clocks changed here on Saturday night, so I guess that 
> shouldn't 
> >> have caused the first error (or should the docs be updated?).
> 
> Horology failures are normal for a day or so on either side 
> of a DST change --- see the "regression tests interpretation" 
> docs.  I have no time right now to examine the other diffs.

The docs say:

====
Some of the queries in the timestamp test will fail if you run the test
on
the day of a daylight-savings time changeover, or the day before or
after
one.
====

Clocks changed at midnight Saturday so I figured a Monday morning run
should be OK. Do they actually change on Sunday at 00:00:00 I wonder?
I'll try again tomorrow.

Regards, Dave.

Mon, 28 Oct 2002 15:58:09 -0000
"Dave Page" <dpage@vale-housing.co.uk>
Re: [HACKERS] Request for supported platforms 
"Dave Page" <dpage@vale-housing.co.uk> writes:
>> Horology failures are normal for a day or so on either side 
>> of a DST change --- see the "regression tests interpretation" 
>> docs.  I have no time right now to examine the other diffs.

> The docs say:

> Some of the queries in the timestamp test will fail if you run the test
> on
> the day of a daylight-savings time changeover, or the day before or
> after
> one.

> Clocks changed at midnight Saturday so I figured a Monday morning run
> should be OK. Do they actually change on Sunday at 00:00:00 I wonder?
> I'll try again tomorrow.

In the US, DST changes occur at 02:00 Sunday, so the affected queries
actually fail starting at 00:00 Sunday and ending 00:00 Tuesday ---
but that's local time in PST8PDT.  The docs are vague because your local
time might vary considerably from that ...

			regards, tom lane

Mon, 28 Oct 2002 13:22:00 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Request for supported platforms 