Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odpovědi
30371 Zobrazení

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
Zrušit
Nejlepší odpověď

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
Zrušit

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

Related Posts Odpovědi Zobrazení Aktivita
0
kvě 25
797
1
dub 25
934
4
čvc 25
4673
1
úno 24
2635
0
říj 24
3968