Docs about INSERT wait in Read Commited transaction

2022-05-08 Thread PG Doc comments form
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.
Thank you
You are doing a great job with PostgreSQL docs!


Re: Docs about INSERT wait in Read Commited transaction

2022-05-08 Thread David G. Johnston
On Saturday, May 7, 2022, PG Doc comments form 
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:

https://www.postgresql.org/docs/current/index-unique-checks.html

David J.