search

toluaina / pgsync

Postgres to Elasticsearch/OpenSearch sync
https://pgsync.com
MIT License
1.11k stars 174 forks source link

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

Open nazihkalo opened 1 year ago

nazihkalo commented 1 year ago

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):

toluaina commented 1 year ago

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