BUG #18324: Duplicate value when I insert values in PK column

Поиск
Список
Период
Сортировка
Искать
От
PG Bug reporting form
Тема
BUG #18324: Duplicate value when I insert values in PK column
Дата
Msg-id
18324-c399192389d72f74@postgresql.org
Список
Дерево обсуждения
BUG #18324: Duplicate value when I insert values in PK column PG Bug reporting form <noreply@postgresql.org>
Re: BUG #18324: Duplicate value when I insert values in PK column "David G. Johnston" <david.g.johnston@gmail.com>
Re: BUG #18324: Duplicate value when I insert values in PK column Laurenz Albe <laurenz.albe@cybertec.at>
The following bug has been logged on the website:

Bug reference:      18324
Logged by:          Mael Villat
Email address:      mael.villat@gmail.com
PostgreSQL version: 16.1
Operating system:   Windows Server
Description:        

Dear Dev team,

I have a table called mdt_prestation with the following column:
colId integer NOT NULL GENERATED BY DEFAULT AS IDENTITY

I have a timesheet app with only one query that INSERT values in this table
(extract from the psql log):
INSERT INTO myTable (Client, Employee)VALUES('1150','185') RETURNING colId

I have about 35 users that uses this app and sometimes we have the following
error:
ERREUR:  la valeur d'une clé dupliquée rompt la contrainte unique «
myTable_pkey» (error duplicate value key, unique constraint violation, )

DETAIL:  La clé « (colid)=(1704236) » existe déjà  (key 1704236 already
exist)

Most of the time we don't have this issue. And the sequence is correct
(sequence = max id value). I'm sure that nobody insert manuel id.
So I believe that there is a concurrency issue in postgresql server with the
sequence when we insert a value.

Best regards 
Mael

В списке pgsql-bugs по дате отправления
От: Christian Maurer
Дата:
От: David G. Johnston
Дата:
FAQ