diff options
| author | Andres Freund | 2018-10-10 20:53:02 +0000 |
|---|---|---|
| committer | Andres Freund | 2018-10-10 20:53:02 +0000 |
| commit | ef493055b67d30393a71c59d6fcbc2bd406528c2 (patch) | |
| tree | 3e376c5917502be6ba4cdf4de649d12f5a9bdb29 /contrib/test_decoding/sql | |
| parent | f82d4d666ff501382b92dfd80eaf1d459e6e84a3 (diff) | |
Force synchronous commit to be enabled for all test_decoding tests.
Without that the tests fail when forced to be run against a cluster
with synchronous_commit = off (as the WAL might not yet be flushed to
disk by the point logical decoding gets called, and thus the expected
output breaks). Most tests already do that, add it to a few newer tests.
Author: Andres Freund
Diffstat (limited to 'contrib/test_decoding/sql')
| -rw-r--r-- | contrib/test_decoding/sql/truncate.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/contrib/test_decoding/sql/truncate.sql b/contrib/test_decoding/sql/truncate.sql index 88f113fd5b1..5aecdf0881f 100644 --- a/contrib/test_decoding/sql/truncate.sql +++ b/contrib/test_decoding/sql/truncate.sql @@ -1,3 +1,6 @@ +-- predictability +SET synchronous_commit = on; + SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); CREATE TABLE tab1 (id serial unique, data int); |