Docs about INSERT wait in Read Commited transaction
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!
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:
https://www.postgresql.org/docs/current/index-unique-checks.html
David J.
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> пише:
Show quoted text
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:
https://www.postgresql.org/docs/current/index-unique-checks.html
David J.