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

Abderrahim · Answer

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

` ``

Related Posts	Replies	Zobrazenia
Project.task ID increment, per minute passed? task id increment	2 dec 24	1579
Import - 'Create if doesn't exist' Solved import create odooV13	1 okt 21	6228
ORM: Create a record with a psecific id Solved create orm id	1 jún 19	6092
Odoo Module not appearing Solved apps create developer odooV13	2 máj 21	12462
Odoov13 reocrds are not created in order of my passsed list create orm sale.order odooV13 create()	0 mar 21	2591

This question has been flagged

Enjoying the discussion? Don't just read, join in!