abc icon indicating copy to clipboard operation
abc copied to clipboard

postgres materialized view support

Open bwalsh opened this issue 6 years ago • 2 comments

Attempting to sync a database with a materialized view.

Expected result: rows in materialized view appear in index. Actual result: document type does not appear in index.

Looks like adaptor queries via

SELECT table_schema,table_name FROM information_schema.tables

Perhaps this is a viable alternative?

SELECT table_schema,table_name FROM information_schema.tables
UNION
SELECT  schemaname, matviewname FROM pg_matviews

Version: 0.6.0 Variant: !oss Go version: go1.10.1 OS: linux Arch: amd64

Checks
  • [x] I have mentioned my abc version in the issue, if applicable.
  • [x] This issue is not a duplicate.
  • [x] This issue has a description.

bwalsh avatar Aug 24 '18 16:08 bwalsh

Follow on question. After, reviewing the build variants, I'm confused. Is it possible to contribute or fork the import functionality?

bwalsh avatar Aug 24 '18 16:08 bwalsh

Currently no. The import part of the project is originally derived from https://github.com/compose/transporter, which is BSD licensed.

We will look into this and see if it's possible to add support for this.

siddharthlatest avatar Aug 28 '18 22:08 siddharthlatest