appbaseio / appbaseio/abc

postgres materialized view support

Abierto
#103 2 comentarios 0 reacciones 0 asignados Ver en GitHub
needs review
Lenguaje dominante
Go
Estrellas
471
Forks
47
Métricas de merge de PR
Sin PR fusionados en 30 d

Descripción

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.

Guía de contribución

Abrir la guía de contribución

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.