Create object with specific ID

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
会計
在庫
PoS
Project
MRP

All apps

全てのポスト人々バッジ

タグ (全て表示)

odoo accounting v14 pos v15

このフォーラムについて

ヘルプ

Create object with specific ID

create id sql increment odooV13

2 返信

8205 ビュー

Benjamin Cherpas

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 'ID already exists'. It's not possible to process like that.

If anyone can help me.

Thank you so much.

Regards.

Ray Carnes (ray)

最善の回答

You should use a different field.

ID is a field maintained by Odoo and not designed to be updatable.

Benjamin Cherpas

著作者

Thanks for your answer ! But I ain't sure I understand the purpose of magic columns and how to use 'em. May you explain me better please? :)

Ray Carnes (ray)

Magic Columns are for Odoo. You need to make your own columns if you want to create with a specific ID. Make your own column and put your information in there. Odoo needs the Magic Columns and you are not supposed to interfere with them.

Benjamin Cherpas

著作者

Thank you for helping me!

Abderrahim oujbih

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	832
Import - 'Create if doesn't exist' 解決済 import create odooV13	1 10月 21	5263
ORM: Create a record with a psecific id 解決済 create orm id	1 6月 19	5433
Odoo Module not appearing 解決済 apps create developer odooV13	2 5月 21	11082
Odoov13 reocrds are not created in order of my passsed list create orm sale.order odooV13 create()	0 3月 21	2009

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！