Re: Concurrent delete and insert on same key, potentially a bug

2025-03-28 Thread Adrian Klaver
On 3/28/25 12:38, Sasa Vilic wrote: Hello, Please excuse my ignorance, because I might be missing something obvious, but how is this not a bug? I simply open 2 terminals and connect to the same database. **TERMINAL 1:** sasa=# create table tst1(id int primary key); CREATE TABLE sasa=# inser

Re: Concurrent delete and insert on same key, potentially a bug

2025-03-28 Thread Gurjeet Singh
On Fri, Mar 28, 2025 at 12:39 PM Sasa Vilic wrote: > > Hello, > > Please excuse my ignorance, because I might be missing something obvious, but > how is this not a bug? > > I simply open 2 terminals and connect to the same database. > > **TERMINAL 1:** > > sasa=# create table tst1(id int primary

Concurrent delete and insert on same key, potentially a bug

2025-03-28 Thread Sasa Vilic
Hello, Please excuse my ignorance, because I might be missing something obvious, but how is this not a bug? I simply open 2 terminals and connect to the same database. **TERMINAL 1:** sasa=# create table tst1(id int primary key); CREATE TABLE sasa=# insert into tst1(id) values(1); INSERT 0 1 sa