Postgres Pro
Downloads
Home   >   mailing lists

Re: Docs about INSERT wait in Read Commited transaction - Mailing list pgsql-docs

From Ivan Tsyba
Subject Re: Docs about INSERT wait in Read Commited transaction
Date
Msg-id CAJQY8UosNct0m0xbD7gkWGs02c0SOZN1DET-Q94jjpV1LrC2SQ@mail.gmail.com
Whole thread Raw
In response to Re: Docs about INSERT wait in Read Commited transaction  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-docs
Tree view
Yes, the behavior is documented there. I would suggest to add one sentence about it to transactions page.

Thank you


пн, 9 трав. 2022, 04:27 користувач David G. Johnston <david.g.johnston@gmail.com> пише:
On Saturday, May 7, 2022, PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/transaction-iso.html
Description:

Hello
I've noticed, if two transactions in read committed mode are trying to
insert same value to unique column, second transaction INSERT will wait for
the first transaction commit or rollback. Can't see this behavior explicitly
stated in the doc about transaction isolation modes.


It is documented elsewhere:


David J.
 

pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Docs about INSERT wait in Read Commited transaction
Next
From: PG Doc comments form
Date:
Subject: correction