BUG #15935: Auto increment column changes on error while inserting (violating unique constraint)

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15935: Auto increment column changes on error while inserting (violating unique constraint)
Дата
Msg-id 15935-20633f1e9fb4d69f@postgresql.org
обсуждение исходный текст
Ответы RE: BUG #15935: Auto increment column changes on error whileinserting (violating unique constraint)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15935
Logged by:          Muhammadali Nazarov
Email address:      muhammadalinazarov@gmail.com
PostgreSQL version: 11.1
Operating system:   Ubuntu 16.04.3 LTS (GNU/Linux 4.4.0-96-generic x86
Description:

I have seen one interesting behavior.
Let me show on example.

create table tmp (
id serial,
user_id int unique not null);

insert into tmp(user_id)
select 1;

our id => 1, autoincrement value 2;
insert into tmp(user_id)
select 1;

violating unique constraint, autoincrement value 3;
insert into tmp(user_id)
select 2;

select id, user_id
from tmp;
id | user_id 
----+---------
  1 |       1
  3 |       2

Is this a bug or no?
Thank you for your attention.


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