Improve test in 009_matviews.pl.
authorAmit Kapila <akapila@postgresql.org>
Mon, 27 Oct 2025 03:52:39 +0000 (03:52 +0000)
committerAmit Kapila <akapila@postgresql.org>
Mon, 27 Oct 2025 03:52:39 +0000 (03:52 +0000)
commit549d9c91b1d2fa38e374c020eb584e3e6836e27c
treecfb760ed04ae47d85c55ef86cedf42b5e9feebe8
parent371a302eecdc82274b0ae2967d18fd726a0aa6a1
Improve test in 009_matviews.pl.

Ensure that the target table on the subscriber exists before executing any
DML intended for replication.

Currently, if the table is missing, the replication logic keeps retrying
until the table is eventually created by the test. Although this behaviour
does not cause test failures, since the table is created after the INSERT
is published and replication eventually succeeds, however, it introduces
unnecessary looping and delays.

Author: Grem Snoort <grem.snoort@gmail.com>
Discussion: https://postgr.es/m/CANV9Qw5HD7=Fp4nox2O7DoVctHoabRRVW9Soo4A=QipqW5B=Tg@mail.gmail.com
src/test/subscription/t/009_matviews.pl