v.23.3Experimental Feature

Fix Materialized View Creation in MaterializedPostgreSQL

Fix create materialized view with MaterializedPostgreSQL #40807 (Maksim Buren).
Fix the creation of materialized views when using the MaterializedPostgreSQL engine in ClickHouse.

Why it matters

This update resolves issues that prevented the successful creation of materialized views with the MaterializedPostgreSQL engine, ensuring proper integration and data replication from PostgreSQL sources. It enhances stability and usability for users relying on materialized views with PostgreSQL-based replicated data.

How to use it

Users can now create materialized views based on tables using the MaterializedPostgreSQL engine without errors. Simply define the materialized view as usual with the appropriate CREATE MATERIALIZED VIEW syntax referencing a MaterializedPostgreSQL table.