PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15935
PG Version11.1
OSUbuntu 16.04.3 LTS (GNU/Linux 4.4.0-96-generic x86
Opened2019-07-31 11:30:06+00
Reported byMuhammadali Nazarov
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15935
Logged by:          Muhammadali Nazarov
Email address:      (redacted)
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.

Messages

DateAuthorSubject
2019-07-31 11:30:06+00PG Bug reporting formBUG #15935: Auto increment column changes on error while inserting (violating unique constraint)
2019-07-31 13:36:11+00David RaymondRE: BUG #15935: Auto increment column changes on error while inserting (violating unique constraint)