aboutsummaryrefslogtreecommitdiff
path: root/src/tutorial/funcs.c
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2008-05-25 21:51:38 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2008-05-25 21:51:38 +0000
commitea2827116540c5d8db51da030a4c4c9d4e4ab130 (patch)
tree698559a16fe7b5e7ebcc90cb06462b42a9fd72c3 /src/tutorial/funcs.c
parent7cff884c3882114b777d3ce84439a4ce3b280a17 (diff)
downloadpostgresql-ea2827116540c5d8db51da030a4c4c9d4e4ab130.tar.gz
postgresql-ea2827116540c5d8db51da030a4c4c9d4e4ab130.zip
Adjust timestamp regression tests to prevent two low-probability failure
cases. Recent buildfarm experience shows that it is sometimes possible to execute several SQL commands in less time than the granularity of Windows' not-very-high-resolution gettimeofday(), leading to a failure because the tests expect the value of now() to change and it doesn't. Also, it was recognized some time ago that the same area of the tests could fail if local midnight passes between the insertion and the checking of the values for 'yesterday', 'tomorrow', etc. Clean all this up per ideas from myself and Greg Stark. There remains a window for failure if the transaction block is entered exactly at local midnight (so that 'now' and 'today' have the same value), but that seems low-probability enough to live with. Since the point of this change is mostly to eliminate buildfarm noise, back-patch to all versions we are still actively testing.
Diffstat (limited to 'src/tutorial/funcs.c')
0 files changed, 0 insertions, 0 deletions