postgres_fdw: Fix tests with ANALYZE and remote sampling
authorMichael Paquier <michael@paquier.xyz>
Wed, 13 Aug 2025 04:11:19 +0000 (13:11 +0900)
committerMichael Paquier <michael@paquier.xyz>
Wed, 13 Aug 2025 04:11:19 +0000 (13:11 +0900)
commit783cbb6d5e8bdf87d321286f210983c177ead967
tree942b416de2e7cb1fc87e67b6db5327eb15d5870c
parent5f19d13dfed35d8d4ed80d555f2d32b106771b61
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