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	Odpovědi	Zobrazení
Project.task ID increment, per minute passed? task id increment	2 pro 24	906
Import - 'Create if doesn't exist' Vyřešeno import create odooV13	1 říj 21	5380
ORM: Create a record with a psecific id Vyřešeno create orm id	1 čvn 19	5524
Odoo Module not appearing Vyřešeno apps create developer odooV13	2 kvě 21	11299
Odoov13 reocrds are not created in order of my passsed list create orm sale.order odooV13 create()	0 bře 21	2063

This question has been flagged

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