public inbox for [email protected]  

help / color / mirror / Atom feed

From: Sagar Tiwari <[email protected]>
To: [email protected]
Subject: Saw some strange behavior when using `INSERT ON CONFLICT` inside a transaction.
Date: Sat, 30 Aug 2025 13:13:35 +0530
Message-ID: <CAJ8WsYMYH0ZbxA4krA0JNnF1fPdvtdANxV-WDbwZCcC++QUODw@mail.gmail.com> (raw)

Repro steps:
* I created the table:
```
create table t (col TEXT primary key);
```

* Open two database consoles and use the following queries in them:

```
1 begin;
2 select txid_current();
3 insert into t (col) values ('test') on conflict (col) do nothing;
4 commit;
```

I ran 1 and 2 in both. It worked for both.
And then I ran query 3 in the first console. It worked.
After that I ran query 3 in the second console. It got stuck!
When I commit the tx in first console, the stuck query in second console
finishes
The transaction isolation level is 'read committed'.

-- 
Best Regards
Sagar Tiwari

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Saw some strange behavior when using `INSERT ON CONFLICT` inside a transaction.
  In-Reply-To: <CAJ8WsYMYH0ZbxA4krA0JNnF1fPdvtdANxV-WDbwZCcC++QUODw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox