FDW Wrappers error: 'component verification failed'

如果你在查询封装器外部表时看到 ERROR: HV000: guest fdw error: component verification failed，这说明配置的 Wasm 包元数据与下载的组件不匹配。作为安全措施，当发生这种不匹配时，Wrappers 扩展会阻止该模块。

🌐 If you are observing an ERROR: HV000: guest fdw error: component verification failed when querying a wrapper foreign tables, it indicates that the configured Wasm package metadata does not match the downloaded component. As a security measure, the Wrappers extension blocks the module when this mismatch occurs.

要解决这个问题，请更新你的外部服务器配置，使用正确的软件包版本和校验和。具体细节取决于具体的封装器，可以在这里找到：https://fdw.dev/catalog/wasm/

🌐 To resolve this, update your foreign server configuration to use the correct package version and checksum. Details depend on the exact Wrapper and can be found here: https://fdw.dev/catalog/wasm/

如何修复配置： 通过 SQL 编辑器 运行以下 SQL：

1
ALTER SERVER example_server OPTIONS (
2
  SET fdw_package_url '[THE_CORRECT_URL]',
3
  SET fdw_package_version '[THE_CORRECT_VERSION]',
4
  SET fdw_package_checksum '[INTERNAL_ID]'
5
);

验证更新： 你可以通过检查服务器选项来确认更新：

1
select srvname, unnest(srvoptions) as option
2
from pg_foreign_server
3
where srvname = 'example_server';

通过查询你的外部表来测试连接：

🌐 Test the connection by querying your foreign table:

1
select * from example_table limit 1;