Skip to content

Commit 066fce7

Browse files
author
Thomas G. Lockhart
committed
Update to suggest using PST8PDT time zone rather than full time zone string.
Include section on error message differences.
1 parent 4bd4a55 commit 066fce7

File tree

1 file changed

+31
-14
lines changed

1 file changed

+31
-14
lines changed

src/test/regress/README

Lines changed: 31 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -6,12 +6,12 @@ Introduction
66
Andrew Yu. It tests standard SQL operations as well as the extensibility
77
capabilities of PostgreSQL.
88

9-
These tests have recently been revised by Marc Fournier and others to
10-
become current for PostgreSQL v6.1. The tests are now packaged as
9+
These tests have recently been revised by Marc Fournier and Thomas Lockhart
10+
to become current for PostgreSQL v6.1. The tests are now packaged as
1111
functional units and should be easier to run and easier to interpret.
1212

1313
Some properly installed and fully functional PostgreSQL installations
14-
can fail these regression tests due to artifacts of floating point
14+
can fail some of these regression tests due to artifacts of floating point
1515
representation and time zone support. The current tests are evaluated
1616
using a simple "diff" algorithm, and are sensitive to small system
1717
differences. For apparently failed tests, examining the differences
@@ -27,13 +27,21 @@ Preparation
2727
files with absolute pathnames and user names.
2828

2929
The postmaster should be invoked with the system time zone set for
30-
Berkeley, California. On some systems, this can be accomplished by
30+
Berkeley, California. On many systems, this can be accomplished by
3131
setting the TZ environment variable before starting the postmaster
3232
(for csh/bash; use set/export for some other shells):
3333

34-
setenv TZ PST8PDT7,M04.01.0,M10.05.03
34+
setenv TZ PST8PDT
35+
date
3536
/usr/local/pgsql/bin/postmaster -s
3637

38+
The "date" command above should have returned the current system time
39+
in the PST8PDT time zone. If the PST8PDT database is not available, then
40+
your system may have returned the time in GMT. If the PST8PDT time zone
41+
is not available, you can set the time zone rules explicitly:
42+
43+
setenv TZ PST8PDT7,M04.01.0,M10.05.03
44+
3745
Directory Layout
3846

3947
input/ .... .source files that are converted using 'make all' into
@@ -73,6 +81,15 @@ Comparing expected/actual output
7381
The files might not compare exactly. The following paragraphs attempt
7482
to explain the differences.
7583

84+
Error message differences
85+
86+
Some of the regression tests involve intentional invalid input values.
87+
Error messages can come from either the Postgres code or from the host
88+
platform system routines. In the latter case, the messages may vary
89+
between platforms, but should reflect similar information. These
90+
differences in messages will result in a "failed" regression test which
91+
can be validated by inspection.
92+
7693
OID differences
7794

7895
There are several places where PostgreSQL OID (object identifiers) appear
@@ -93,12 +110,14 @@ DATE/TIME differences
93110
is running in the same time zone as Berkeley, California. See details in
94111
the section on how to run the regression tests.
95112

96-
If you do not explicitly set your time zone environment to PST/PDT, then
113+
If you do not explicitly set your time zone environment to PST8PDT, then
97114
most of the date and time results will reflect your local time zone and
98115
will fail the regression testing.
99116

100-
There appear to be some systems which do not accept the same syntax for
101-
setting the local time zone.
117+
There appears to be some systems which do not accept the recommended syntax
118+
for explicitly setting the local time zone rules. Some systems using the
119+
public domain time zone package exhibit minor problems with pre-1970 PDT
120+
times, representing them in PST instead.
102121

103122
FLOATING POINT differences
104123

@@ -168,11 +187,9 @@ Current release notes (Thomas.Lockhart@jpl.nasa.gov)
168187

169188
Three new data types (datetime, timespan, and circle) have been added to
170189
the native set of PostgreSQL types. Points, boxes, paths, and polygons
171-
have had their output formats improved, but the old-style input formats
172-
are accepted by v6.1. The source data files have not been updated to the
173-
new formats, but should be for the next release. The polygon output in
174-
misc.out has only been spot-checked for correctness relative to the
175-
original regression output.
190+
have had their output formats made consistant across the data types.
191+
The polygon output in misc.out has only been spot-checked for correctness
192+
relative to the original regression output.
176193

177194
PostgreSQL v6.1 introduces a new, alternate optimizer which uses "genetic"
178195
algorithms. These algorithms introduce a random behavior in the ordering
@@ -204,6 +221,6 @@ Sample timing results
204221
to run, presumably due to the timing vagaries of multitasking systems.
205222

206223
Time System
207-
06:12 Pentium Pro 180, 32MB, Linux 2.0.27, gcc 2.7.2 -O2 -m486
224+
06:12 Pentium Pro 180, 32MB, Linux 2.0.30, gcc 2.7.2 -O2 -m486
208225
12:06 P-100, 48MB, Linux 2.0.29, gcc
209226
39:58 Sparc IPC 32MB, Solaris 2.5, gcc 2.7.2.1 -O -g

0 commit comments

Comments
 (0)