Ir al contenido
Menú
Se marcó esta pregunta
2 Respuestas
6495 Vistas

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 ?? 

Avatar
Descartar
Mejor respuesta

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/current/sql-createsequence.html

You can use _sequence attribute on model to change sequence field.

Avatar
Descartar
Autor Mejor respuesta

Thank you Jigar Patel

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
0
nov 21
3064
0
feb 25
1575
2
ene 25
8203
2
ene 24
10138
3
oct 23
8661