How to delete the record id or Primary key of a table in Postgresql during deletion of a record in odoo form

Question

When i am deleting a record in postgresql DB from odoo front-end and if again i am creating a new record then the primary key index changed like if i am deleting id=2 record and if again creating new record ,then it stores id =3.. How ??

Jigar Patel (jat) · Accepted Answer

Actually, Odoo automatically apply sequence on ID field. This is done by _sequence attribute on model and it's apply on 'ID' field here https://github.com/odoo/odoo/blob/12.0/odoo/models.py#L3630
If you check your table in Postgresql then ID column have description like id integer NOT NULL DEFAULT nextval('model_name_id_seq'::regclass). Here,  nextval will execute sequence which will auto increment index.
You can read in detail what is exact nextval function? https://www.postgresql.org/docs/curr

Nikunja Maharana · Answer

Thank you Jigar Patel

相關帖文	回覆	瀏覽次數
Odoo: Separate server for DB and Odoo Server --data-dir configuration postgresql odoo12.0	0 11月 21	3061
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released postgresql	0 2月 25	1561
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied postgresql	2 1月 25	8157
Odoo backend to Google Data Studio 已解決 postgresql	2 1月 24	10138
How to write Record Rule with domain based on the company_dependent Fields 已解決 odoo12.0	3 10月 23	8635

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！