pgsync icon indicating copy to clipboard operation
pgsync copied to clipboard

[Question/Feature Request] Materialized views built from `base_tables` spanning multiple schemas

Open nazihkalo opened this issue 3 years ago • 1 comments

PGSync version: 2.4.0

Postgres version: debezium/postgres:15

Elasticsearch version: 7.17.7

Redis version: 7.0

Python version: 3.7

Problem Description:

Does the materialized view option support having base tables that span multiple schemas?

From the examples I've seen only base_tables within the same schema as the MV are used.

Error Message (if any):



nazihkalo avatar Dec 14 '22 04:12 nazihkalo

Hmm. The base tables cannot currently span multiple schemas. If this is a common use case, I could look into it

toluaina avatar Dec 18 '22 20:12 toluaina