v.21.11Improvements

PostgreSQL Foreign Tables: Added Partitioned Table Prefix 'p' for Replica Identity Index Query

Official CH changelog text
PostgreSQL foreign tables: Added partitioned table prefix 'p' for the query for fetching replica identity index. #29828 (Shoh Jahon).
Added support for using the partitioned table prefix 'p' in PostgreSQL foreign tables when querying for the replica identity index.

Why it matters

This feature addresses the issue of correctly identifying the replica identity index on partitioned PostgreSQL foreign tables. It ensures that ClickHouse can accurately fetch and use the replica identity index by including the 'p' prefix in queries, improving compatibility and correctness when working with partitioned foreign tables.

How to use it

This improvement is applied automatically when querying PostgreSQL foreign tables with partitions; no additional configuration is required from the user.

Related resources

PreviousNext