/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/test_decoding/specs/delayed_startup.spec
24 строки
769 B
Robert Haas
Introduce logical decoding.
04 мар 2014, 01:32
04 мар 2014, 01:32
b89e151
Код
Авторство
О чём код?
setup { DROP TABLE IF EXISTS do_write; CREATE TABLE do_write(id serial primary key); } teardown { DROP TABLE do_write; SELECT 'stop' FROM pg_drop_replication_slot('isolation_slot'); } session "s1" setup { SET synchronous_commit=on; } step "s1b" { BEGIN ISOLATION LEVEL SERIALIZABLE; } step "s1w" { INSERT INTO do_write DEFAULT VALUES; } step "s1c" { COMMIT; } session "s2" setup { SET synchronous_commit=on; } step "s2init" {SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding');} step "s2start" {SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false');} permutation "s1b" "s1w" "s2init" "s1c" "s2start" "s1b" "s1w" "s1c" "s2start" "s1b" "s1w" "s2start" "s1c" "s2start"