diff options
Diffstat (limited to 'contrib/test_decoding')
| -rw-r--r-- | contrib/test_decoding/expected/decoding_into_rel.out | 2 | ||||
| -rw-r--r-- | contrib/test_decoding/sql/decoding_into_rel.sql | 4 |
2 files changed, 6 insertions, 0 deletions
diff --git a/contrib/test_decoding/expected/decoding_into_rel.out b/contrib/test_decoding/expected/decoding_into_rel.out index 2671258f5d..be759caa31 100644 --- a/contrib/test_decoding/expected/decoding_into_rel.out +++ b/contrib/test_decoding/expected/decoding_into_rel.out @@ -1,6 +1,8 @@ -- test that we can insert the result of a get_changes call into a -- logged relation. That's really not a good idea in practical terms, -- but provides a nice test. +-- predictability +SET synchronous_commit = on; SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); ?column? ---------- diff --git a/contrib/test_decoding/sql/decoding_into_rel.sql b/contrib/test_decoding/sql/decoding_into_rel.sql index 3704821bcc..54670fd39e 100644 --- a/contrib/test_decoding/sql/decoding_into_rel.sql +++ b/contrib/test_decoding/sql/decoding_into_rel.sql @@ -1,6 +1,10 @@ -- test that we can insert the result of a get_changes call into a -- logged relation. That's really not a good idea in practical terms, -- but provides a nice test. + +-- predictability +SET synchronous_commit = on; + SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); -- slot works |