duplicate sequence, it is possible?

Поиск
Список
Период
Сортировка
От Anibal David Acosta
Тема duplicate sequence, it is possible?
Дата
Msg-id 001b01cc7667$2f956250$8ec026f0$@devshock.com
обсуждение исходный текст
Ответы Re: duplicate sequence, it is possible?
Список pgsql-general

Hi everyone.

 

I have a table with a PK, this table has a lot of insert per second (100 ~ 150 insert /sec)

Sometimes, a get a duplicate key error, but ID is generated from a function (VOLATILE). This function has just one line (select nextval('XXX'))

 

Is possible that this function return same ID for two diff call?

 

Postgres version is 9.0

 

Thanks!

 

В списке pgsql-general по дате отправления: