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)  (David Raymond <David.Raymond@tomtom.com>)
Список 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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15934: pg_dump output in wrong order if custom operator class is used as subtype_opclass in a range type
Следующее
От: David Raymond
Дата:
Сообщение: RE: BUG #15935: Auto increment column changes on error whileinserting (violating unique constraint)