diff options
| author | Noah Misch <noah@leadboat.com> | 2014-12-15 20:56:09 -0500 |
|---|---|---|
| committer | Noah Misch <noah@leadboat.com> | 2014-12-15 20:56:09 -0500 |
| commit | 0916eba131530b296f86137759a32f66ffedff7b (patch) | |
| tree | fb5f8cfc2eb078386a3887795b8dd26fe327be4c /src/test/modules/commit_ts/expected/commit_timestamp_1.out | |
| parent | 733a264ddc1ad29d9cb91cbd712c1ef5f92886c8 (diff) | |
| download | postgresql-0916eba131530b296f86137759a32f66ffedff7b.tar.gz postgresql-0916eba131530b296f86137759a32f66ffedff7b.zip | |
Fix commit_ts test suite for systems with coarse timestamp granularity.
Noticed on a couple of Windows configurations.
Petr Jelinek, reviewed by Michael Paquier.
Diffstat (limited to 'src/test/modules/commit_ts/expected/commit_timestamp_1.out')
| -rw-r--r-- | src/test/modules/commit_ts/expected/commit_timestamp_1.out | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/modules/commit_ts/expected/commit_timestamp_1.out b/src/test/modules/commit_ts/expected/commit_timestamp_1.out index 51f89c20bd0..a4253faa7b7 100644 --- a/src/test/modules/commit_ts/expected/commit_timestamp_1.out +++ b/src/test/modules/commit_ts/expected/commit_timestamp_1.out @@ -13,7 +13,7 @@ INSERT INTO committs_test DEFAULT VALUES; INSERT INTO committs_test DEFAULT VALUES; SELECT id, pg_xact_commit_timestamp(xmin) >= ts, - pg_xact_commit_timestamp(xmin) < now(), + pg_xact_commit_timestamp(xmin) <= now(), pg_xact_commit_timestamp(xmin) - ts < '60s' -- 60s should give a lot of reserve FROM committs_test ORDER BY id; @@ -29,6 +29,6 @@ HINT: Make sure the configuration parameter "track_commit_timestamp" is set. SELECT pg_xact_commit_timestamp('2'::xid); ERROR: could not get commit timestamp data HINT: Make sure the configuration parameter "track_commit_timestamp" is set. -SELECT x.xid::text::bigint > 0, x.timestamp > '-infinity'::timestamptz, x.timestamp < now() FROM pg_last_committed_xact() x; +SELECT x.xid::text::bigint > 0, x.timestamp > '-infinity'::timestamptz, x.timestamp <= now() FROM pg_last_committed_xact() x; ERROR: could not get commit timestamp data HINT: Make sure the configuration parameter "track_commit_timestamp" is set. |