]> git.ipfire.org Git - thirdparty/postgresql.git/commit
postgres_fdw: Fix tests with ANALYZE and remote sampling
authorMichael Paquier <michael@paquier.xyz>
Wed, 13 Aug 2025 04:11:51 +0000 (13:11 +0900)
committerMichael Paquier <michael@paquier.xyz>
Wed, 13 Aug 2025 04:11:51 +0000 (13:11 +0900)
commit327bd6111aede2a41f8891d2cd2501c773bc047e
tree6987754d62e686726f14b5521b635ed8368d480e
parentc13dd7d50f21268dc64b4b3edbce31993985ab12
postgres_fdw: Fix tests with ANALYZE and remote sampling

The tests fixed in this commit were changing the sampling setting of a
foreign server, but then were analyzing a local table instead of a
foreign table, meaning that the test was not running for its original
purpose.

This commit changes the ANALYZE commands to analyze the foreign table,
and changes the foreign table definition to point to a valid remote
table.  Attempting to analyze the foreign table "analyze_ftable" would
have failed before this commit, because "analyze_rtable1" is not defined
on the remote side.

Issue introduced by 8ad51b5f446b.

Author: Corey Huinker <corey.huinker@gmail.com>
Discussion: https://postgr.es/m/CADkLM=cpUiJ3QF7aUthTvaVMmgQcm7QqZBRMDLhBRTR+gJX-Og@mail.gmail.com
Backpatch-through: 16
contrib/postgres_fdw/expected/postgres_fdw.out
contrib/postgres_fdw/sql/postgres_fdw.sql