Re: Time delayed LR (WAS Re: logical replication restrictions)

Поиск
Список
Период
Сортировка
От Melih Mutlu
Тема Re: Time delayed LR (WAS Re: logical replication restrictions)
Дата
Msg-id CAGPVpCS7GnrTy4dL61Cp2LP1Z=huO4+_MpkTFG=sK5dS4WexHg@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Time delayed LR (WAS Re: logical replication restrictions)  ("Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>)
Ответы RE: Time delayed LR (WAS Re: logical replication restrictions)
Список pgsql-hackers
Дерево обсуждения
Hi,

I've a question about 032_apply_delay.pl.

+# Test ALTER SUBSCRIPTION. Delay 86460 seconds (1 day 1 minute).
+$node_subscriber->safe_psql('postgres',
+    "ALTER SUBSCRIPTION tap_sub SET (min_apply_delay = 86460000)"
+);
+
+# New row to trigger apply delay.
+$node_publisher->safe_psql('postgres',
+    "INSERT INTO test_tab VALUES (0, 'foobar')");
+

I couldn't quite see how these lines test whether ALTER SUBSCRIPTION successfully worked.
Don't we need to check that min_apply_delay really changed as a result?

But also I see that subscription.sql already tests this ALTER SUBSCRIPTION behaviour.

Best,
--
Melih Mutlu
Microsoft

В списке pgsql-hackers по дате отправления: