appbaseio / appbaseio/abc

postgres materialized view support

Aperta
#103 2 commenti 0 reazioni 0 assegnatari Vedi su GitHub
needs review
Lingua principale
Go
Stelle
471
Fork
47
Metriche di merge delle PR
Nessuna PR unita negli ultimi 30g

Descrizione

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](https://github.com/appbaseio/abc/blob/2b659e2502a4c5788254924590a18bab38c5be47/adaptor/postgres/reader.go#L63) 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.

Guida per i contributori

Apri la guida per i contributori

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.