Create object with specific ID

Question

Hi,

I'd like to use the create() method to create objects with a specific ID in database like :
self.env['res.partner'].create({'id': 450, 'name': 'TEST'}) But, the ID keeps going to increment normally : 1, 2, 3, etc. and doesn't be 450  as I want.
I think it's because there is DEFAULT in database : *nextval('res_partner_id_seq'::regclass)* but even if I remove it, it still increments as a simple ID.

I don't want to use an SQL request like UPDATE because, in my code, there are SQL errors like

Ray Carnes (ray) · Accepted Answer

You should use a different field.
ID is a field maintained by Odoo and not designed to be updatable.
See also:  https://www.odoo.com/forum/help-1/question/what-are-the-magic-columns-why-are-they-so-magical-120123 [1]

[1] https://www.odoo.com/forum/help-1/question/what-are-the-magic-columns-why-are-they-so-magical-120123

UNIVERO DOO, Abderrahim · Answer

Well, you can use this
` ``
SELECT setval('public."table_name_id_seq"',
(SELECT MAX(id) FROM public.table_name)
);

` ``

Gerelateerde posts	Antwoorden	Weergaven
Project.task ID increment, per minute passed? task id increment	2 dec. 24	1901
Import - 'Create if doesn't exist' Opgelost import create odooV13	1 okt. 21	6609
ORM: Create a record with a psecific id Opgelost create orm id	1 jun. 19	6395
Odoo Module not appearing Opgelost apps create developer odooV13	2 mei 21	13249
Odoov13 reocrds are not created in order of my passsed list create orm sale.order odooV13 create()	0 mrt. 21	2832

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!