Skip to content

Commit 8cd571b

Browse files
committed
Clarify exactly when DST-changeover-induced regression test failures
can be expected to occur.
1 parent 3a8f67d commit 8cd571b

File tree

1 file changed

+16
-4
lines changed

1 file changed

+16
-4
lines changed

doc/src/sgml/regress.sgml

Lines changed: 16 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $Header: /cvsroot/pgsql/doc/src/sgml/regress.sgml,v 1.31 2003/03/13 01:30:29 petere Exp $ -->
1+
<!-- $Header: /cvsroot/pgsql/doc/src/sgml/regress.sgml,v 1.32 2003/04/06 17:47:24 tgl Exp $ -->
22

33
<chapter id="regress">
44
<title id="regress-title">Regression Tests</title>
@@ -201,14 +201,26 @@ gmake installcheck
201201
<title>Date and time differences</title>
202202

203203
<para>
204-
Some of the queries in the <filename>horology</filename> test will
204+
A few of the queries in the <filename>horology</filename> test will
205205
fail if you run the test on the day of a daylight-saving time
206-
changeover, or the day before or after one. These queries assume
207-
that the intervals between midnight yesterday, midnight today and
206+
changeover, or the day after one. These queries expect that
207+
the intervals between midnight yesterday, midnight today and
208208
midnight tomorrow are exactly twenty-four hours --- which is wrong
209209
if daylight-saving time went into or out of effect meanwhile.
210210
</para>
211211

212+
<note>
213+
<para>
214+
Because USA daylight-saving rules are used, this problem always
215+
occurs on the first Sunday of April, the last Sunday of October,
216+
and their following Mondays, regardless of when daylight-saving
217+
is in effect where you live. Also note that the problem appears or
218+
disappears at midnight Pacific time (UTC-7 or UTC-8), not midnight
219+
your local time. Thus the failure may appear late on Saturday or
220+
persist through much of Tuesday, depending on where you live.
221+
</para>
222+
</note>
223+
212224
<para>
213225
Most of the date and time results are dependent on the time zone
214226
environment. The reference files are generated for time zone

0 commit comments

Comments
 (0)