Providing custom _id for documents

[AdamPzpn]

Trying inserting data into foregin table ends with ignore for _id parameter.

Example: INSERT INTO warehouse VALUES (uuid_generate_v4()::text, 2, 'Laptop', '2015-11-11T08:13:10Z');

Creates: "_id" : ObjectId("53720b1904864dc1f5a571a0"), "warehouse_id" : 2, "warehouse_name" : "Laptop", "warehouse_created" : ISODate("2015-11-11T08:13:10Z")

How can I insert literal _id as string into entity?

[jeevanladhe]

Hi,

Can you please let us know:

1. How is your table defined on Mongo and
2. and the definition for it as a foreign table on PostgreSQL.

Regards, Jeevan Ladhe

On Thu, Dec 30, 2021 at 2:12 AM AdamPzpn @.***> wrote:

Trying inserting data into foregin table ends with ignore for _id parameter.

Example: INSERT INTO warehouse VALUES (uuid_generate_v4()::text, 2, 'Laptop', '2015-11-11T08:13:10Z');

Creates: "_id" : ObjectId("53720b1904864dc1f5a571a0"), "warehouse_id" : 2, "warehouse_name" : "Laptop", "warehouse_created" : ISODate("2015-11-11T08:13:10Z")

How can I insert literal _id as string into entity?

— Reply to this email directly, view it on GitHub https://github.com/EnterpriseDB/mongo_fdw/issues/154, or unsubscribe https://github.com/notifications/unsubscribe-auth/AQKBZ4VRSU7RFUPRVGFXPADUTNXEXANCNFSM5K6SCK2A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you are subscribed to this thread.Message ID: @.***>

[AdamPzpn]

No problem.

Ad.1

{ "_id" : "1558aeb1-f4fa-4914-82d1-1026d6997976", "param1" : "fa8118db-c004-442d-92e6-00ed3c50a8cb", "param2" : "56cfe38d-c3b7-4ef3-a6f4-ca8799a2b14b", "param3" : "5f6cb622-f8d1-4e08-80ba-0cf3b740641e", "dateFrom" : "2019-10-27T21:19:48Z", "dateTo" : null, "esbSchemaVersion" : 1, "esbExtIds" : [ { "sourceName" : "system", "sourceId" : "456087" } ], "esbVersion" : 1 }

AD.2

CREATE FOREIGN TABLE mongodb.collection( "_id" name NULL COLLATE "C", "param1" text NULL, "param2" text NULL, "param3" text NULL, "dateFrom" text NULL, "dateTo" text NULL, "esbSchemaVersion" int4 NULL, "esbVersion" int4 NULL, "esbExtIds" json NULL ) SERVER mongo_server OPTIONS (database 'mongoDatabase', collection 'collection');

[vaibhavdalvi93]

Hi @AdamPzpn ,

Providing custom _id for a document not supported. Currently, mongo_fdw ignores the value of the first column which is the row identifier in MongoDb (_id) and lets MongoDB insert the unique value for that column.

We will do more studies to try to support this feature in near future.