Thread: 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:
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> пише:
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.