Copy and Insert a document on Same collection

[Asoka Sampath Edussooriya]

Hi,

Can anyone help me to copy and insert a document in same collection. I tried following on mongo command shell. but it gives me an error. the reason is the same mongo _id. the whole document is going to copy including mongo _id. following is the way i have tried.

db.pages.find().limit(1).forEach(function(x){db.pages.insert(x)});

the error i got is -

E11000 duplicate key error index: XXXX.pages.$_id_  dup key: { : ObjId(4e98157f3b9f5f202e000000) }

Thanks!

Asoka


--
Asoka Sampath Edussooriya

[Eliot Horowitz]

What are you trying to do exactly?

_id has to be unique.

You could do this:

> db.pages.find().limit(1).forEach(function(x){ delete x._id; db.pages.insert(x)});

> --
> You received this message because you are subscribed to the Google Groups
> "mongodb-user" group.
> To post to this group, send email to mongod...@googlegroups.com.
> To unsubscribe from this group, send email to
> mongodb-user...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/mongodb-user?hl=en.
>

[Asoka Sampath Edussooriya]

Hi Eliot,

just a simple thing i want to do. duplicating a document with same fields with a new mongo _id.

Thanks!

Asoka

--
Asoka Sampath Edussooriya

[Edi]

it works !. thanks !