Insert does not support RETURNING

[lukeyang88]

INSERT INTO "public"."Animal" ("scopeId","_id","type","name","age","weight","height","temperature") VALUES (3, '6742be42d30bfad0f236731b', 'Dog', 'MyBud
dy', 5, 30.5, 60.2, 37.5) RETURNING "public"."Animal"."_id";
ERROR: RETURNING is not supported by this FDW

We are trying to use prisma to communicate with mongodb FDW.

Wonder when you will have RETURNING support added or something we did wrong with setup?

Thanks,

Luke

[vaibhavdalvi93]

Thank you, @lukeyang88 for reporting an issue. RETURNING is not supported with mongo_fdw. We need further understanding and analysis of that on MongoDB as well as on the extension side. However, we don’t have any immediate plans to support that. Feel free to propose a patch if you would like to contribute. We will take it further by reviewing/commenting. And if it suits well, will potentially merge it.

[lukeyang88]

I found a work around to support RETURNING, but now I am facing the issue to support customized _id for the document -- seems it is still not supported since the wrapper just ignored the _id I provided for INSERT. Do you have plan to add this support -- looks like to me it is very necessary for different use cases.

[vaibhavdalvi93]

Thank you, @lukeyang88 for an update. I can understand your concern regarding customized _id and we need to have further analysis of that on MongoDB as well as on the extension. However, we don’t have any immediate plans to support that. Feel free to propose a patch if you would like to contribute. We will take it further by reviewing/commenting.