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

CRM
e-Commerce
회계
재고 관리
PoS
프로젝트
MRP

All apps

모든 게시물 사용자 배지

태그 (모두 보기)

odoo accounting v14 pos v15

게시판 정보

도움말

Create object with specific ID

create id sql increment odooV13

2 답글

9062 화면

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

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	1609
Import - 'Create if doesn't exist' 해결 완료 import create odooV13	1 10월 21	6238
ORM: Create a record with a psecific id 해결 완료 create orm id	1 6월 19	6113
Odoo Module not appearing 해결 완료 apps create developer odooV13	2 5월 21	12494
Odoov13 reocrds are not created in order of my passsed list create orm sale.order odooV13 create()	0 3월 21	2620

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!