select,update,delete error

[digoal]

use demo.sh

Cannot transform anything else than mappings and sequences to rows.

[pashinin]

I wanted to report exactly the same error: Cannot transform anything else than mappings andsequences to rows when I update a row. It looks like the error is from Multicorn, but I don't know why it happens.

PostgreSQL 9.5, master branch of multicorn and pg-es-fdw, Ubuntu 16.04

[schumajs]

Hey guys, I'm having exactly the same issue. PG 9.5.3, Ubuntu 16.04 as well. Any update on this?

[mighty-nyaina]

Hi everyone, same issues for me. Any solution on this?

[sign0]

Hi, exactly same issue for me... (Ubuntu 14.04, Postgresql 9.3, elasticsearch 5.1).

Maybe the problem is the version of elasticsearch, I'll downgrade to es 1.7, see if it fixes the problem ... (https://www.elastic.co/guide/en/elasticsearch/reference/2.0/breaking-changes-2.0.html)

UPDATE : The problem is the version of elasticsearch. After a downgrade to es 1.7.6, the data wrapper works fine. 👍

[alecsvalentinpopa]

Hi everyone,

I just found a workaround for this.
Modify your Postgresql trigger for update with same query as from insert trigger.
Elasticsearch sees that you are trying to insert a new document with existing id => and it will update your document with your new data

[yesyo]

I actually know nothing about python or elasticsearch. But I think the url of the request to get the search results is wrong. On https://github.com/Mikulas/pg-es-fdw/blob/master/dite/__init__.py#L45, it should be:

"/%s/%s/_search?size=10000"

Also, on https://github.com/Mikulas/pg-es-fdw/blob/master/dite/__init__.py#L48, should yield a empty dictionary instead:

yield {}

Modify the two lines, reinstall this FDW(run python setup.py install again), restart postgres(any idea how to reload without restart the service?), it should be working properly.

I'm running PostgreSQL 9.6.3 and Elasticsearch 5.4 on postgres:9.6 docker image.