Add Query DSL support - Githubissues

matthewfranglen / postgres-elasticsearch-fdw

Postgres to Elastic Search Foreign Data Wrapper

MIT License

108 stars 32 forks source link

Add Query DSL support #20

Closed matthewfranglen closed 3 years ago

matthewfranglen commented 3 years ago

Fixes https://github.com/matthewfranglen/postgres-elasticsearch-fdw/issues/19

The query column must remain TEXT as there is no operator support for JSON equality tests. The equality test is required to prevent the FDW from filtering all the rows on return.

ogierpaul commented 3 years ago

Hello. Yes it works fine, thank you. I arrived to the same conclusion as well (altough not as elegant as yours). Thank you very much!

matthewfranglen commented 3 years ago

Great. I'll make a release for this then.

matthewfranglen commented 3 years ago

Released version 0.11.0 with this fix https://pypi.org/project/pg-es-fdw/