Fix subscription test

petere · petere · commit 806f9dc02aea · 2019-11-09T16:03:00.000+01:00
After altering a subscription, we should wait until the updated table
sync data has been fetched by the subscriber.
diff --git a/src/test/subscription/t/008_diff_schema.pl b/src/test/subscription/t/008_diff_schema.pl
@@ -102,6 +102,9 @@ sub wait_for_caught_up
 $node_subscriber->safe_psql('postgres',
 	"ALTER SUBSCRIPTION tap_sub REFRESH PUBLICATION");
 
+$node_subscriber->poll_query_until('postgres', $synced_query)
+  or die "Timed out while waiting for subscriber to synchronize data";
+
 # Add replica identity column.  (The serial is not necessary, but it's
 # a convenient way to get a default on the new column so that rows
 # from the publisher that don't have the column yet can be inserted.)
