Ir al contenido
Menú
Se marcó esta pregunta

Hi,

Till yesterday everything was good on Odoo. But now when any of the employee in our company (or myself) save the Timesheet, we get the following errors:

duplicate key value violates unique constraint "hr_timesheet_sheet_sheet_pkey"

DETAIL: Key (id)=(91) already exists.

The id keeps changing for all employees.
I would really appreciate any help with this.
Thanks.

Avatar
Descartar
Mejor respuesta

This happend to me - it turns out you need to resync your primary key fields in Postgres. The key is the SQL statement:

SELECT setval('tablename_id_seq', (SELECT MAX(id) FROM tablename)+1);

Avatar
Descartar

Please use a readable formatting. The default is good enough.

Publicaciones relacionadas Respuestas Vistas Actividad
0
may 25
819
1
abr 25
942
4
jul 25
4721
1
feb 24
2651
0
oct 24
3972