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)
);

` ``

相关帖文	回复	查看
Project.task ID increment, per minute passed? task id increment	2 12月 24	991
Import - 'Create if doesn't exist' 已解决 import create odooV13	1 10月 21	5452
ORM: Create a record with a psecific id 已解决 create orm id	1 6月 19	5573
Odoo Module not appearing 已解决 apps create developer odooV13	2 5月 21	11381
Odoov13 reocrds are not created in order of my passsed list create orm sale.order odooV13 create()	0 3月 21	2098

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！