]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix EXCEPT publication test to check subscriber
authorFujii Masao <fujii@postgresql.org>
Fri, 24 Jul 2026 06:44:56 +0000 (15:44 +0900)
committerFujii Masao <fujii@postgresql.org>
Fri, 24 Jul 2026 06:46:15 +0000 (15:46 +0900)
commit72207b17daa328d83b1609b4bc5cc4047fe4ba01
tree6a6b66f7f726240e6e6de8ac5131a29fe6a284b4
parent41be67e534ffccd055922482c17b874fb7a74f30
Fix EXCEPT publication test to check subscriber

Commit fd366065e06 added tests intended to verify that rows inserted
on the publisher are replicated to the subscriber when using multiple
publications, with one excluding the target table via EXCEPT and
another including it.

However, the tests queried the publisher instead of the subscriber.
Since the rows were inserted directly into the publisher, the checks
would always succeed, providing no coverage of replication.

Fix this by querying the subscriber so the tests verify the replicated
state.

Author: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Ayush Tiwari <ayushtiwari.slg01@gmail.com>
Reviewed-by: Amit Kapila <amit.kapila16@gmail.com>
Discussion: https://postgr.es/m/CAHGQGwGfXUO7f4t6KNGurYwg6QsnLtpP0K3EACbAwYWtxGfKfQ@mail.gmail.com
Backpatch-through: 19
src/test/subscription/t/037_except.pl