MIME-Version: 1.0
References: <165196152696.668.3099435890630131836@wrigleys.postgresql.org>
 <CAKFQuwbkCJ=BBGtunXMEdRCEpXgWu3jr-Fw-hSFKdJMHq-owTw@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwbkCJ=BBGtunXMEdRCEpXgWu3jr-Fw-hSFKdJMHq-owTw@mail.gmail.com>
From: Ivan Tsyba <ivantsyba@gmail.com>
Date: Mon, 9 May 2022 04:36:24 +0300
Message-ID: 
 <CAJQY8UosNct0m0xbD7gkWGs02c0SOZN1DET-Q94jjpV1LrC2SQ@mail.gmail.com>
Subject: Re: Docs about INSERT wait in Read Commited transaction
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002c09f205de8a3d7a"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJQY8UosNct0m0xbD7gkWGs02c0SOZN1DET-Q94jjpV1LrC2SQ%40mail.gmail.com>
Precedence: bulk

--0000000000002c09f205de8a3d7a
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Yes, the behavior is documented there. I would suggest to add one sentence
about it to transactions page.

Thank you


=D0=BF=D0=BD, 9 =D1=82=D1=80=D0=B0=D0=B2. 2022, 04:27 =D0=BA=D0=BE=D1=80=D0=
=B8=D1=81=D1=82=D1=83=D0=B2=D0=B0=D1=87 David G. Johnston <
david.g.johnston@gmail.com> =D0=BF=D0=B8=D1=88=D0=B5:

> 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.
>
>

--0000000000002c09f205de8a3d7a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div>Yes, the behavior is documented there. I would sugge=
st to add one sentence about it to transactions page.<div dir=3D"auto"><br>=
</div><div dir=3D"auto">Thank you</div><br><br><div class=3D"gmail_quote"><=
div dir=3D"ltr" class=3D"gmail_attr">=D0=BF=D0=BD, 9 =D1=82=D1=80=D0=B0=D0=
=B2. 2022, 04:27 =D0=BA=D0=BE=D1=80=D0=B8=D1=81=D1=82=D1=83=D0=B2=D0=B0=D1=
=87 David G. Johnston &lt;<a href=3D"mailto:david.g.johnston@gmail.com">dav=
id.g.johnston@gmail.com</a>&gt; =D0=BF=D0=B8=D1=88=D0=B5:<br></div><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc s=
olid;padding-left:1ex">On Saturday, May 7, 2022, PG Doc comments form &lt;<=
a href=3D"mailto:noreply@postgresql.org" target=3D"_blank" rel=3D"noreferre=
r">noreply@postgresql.org</a>&gt; wrote:<br><blockquote class=3D"gmail_quot=
e" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">=
The following documentation comment has been logged on the website:<br>
<br>
Page: <a href=3D"https://www.postgresql.org/docs/14/transaction-iso.html" t=
arget=3D"_blank" rel=3D"noreferrer">https://www.postgresql.org/docs/14/tran=
saction-iso.html</a><br>
Description:<br>
<br>
Hello<br>
I&#39;ve noticed, if two transactions in read committed mode are trying to<=
br>
insert same value to unique column, second transaction INSERT will wait for=
<br>
the first transaction commit or rollback. Can&#39;t see this behavior expli=
citly<br>
stated in the doc about transaction isolation modes.<br><br>
</blockquote><div><br></div><div>It is documented elsewhere:</div><div><br>=
</div><div><a href=3D"https://www.postgresql.org/docs/current/index-unique-=
checks.html" target=3D"_blank" rel=3D"noreferrer">https://www.postgresql.or=
g/docs/current/index-unique-checks.html</a></div><div><br></div><div>David =
J.</div><div>=C2=A0</div>
</blockquote></div></div></div>

--0000000000002c09f205de8a3d7a--