Se rendre au contenu
Menu
Cette question a été signalée

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
Ignorer
Meilleure réponse

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
Ignorer

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

Publications associées Réponses Vues Activité
0
mai 25
796
1
avr. 25
934
4
juil. 25
4669
1
févr. 24
2635
0
oct. 24
3967