The following bug has been logged on the website:
Bug reference: 15935
Logged by: Muhammadali Nazarov
Email address: muhammadalinazarov(at)gmail(dot)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.