<div dir='rtl'><div dir="ltr">Hi,</div>
<div dir="ltr">I have a stock table.</div>
<div dir="ltr"> </div>
<div dir="ltr">One of the users in the system ran this query: update stock set quantity=quantity-5 where stockid=100 (from his client application).</div>
<div dir="ltr">On the same time I ran from pg-admin this query:</div>
<div dir="ltr"> </div>
<div dir="ltr">do $$<br />begin<br />alter table stock disable trigger stock_aftertrigger;<br />update stock set stock=0 where stockid=106;<br />alter table stock enable trigger stock_aftertrigger;<br />end; $$</div>
<div dir="ltr"> </div>
<div dir="ltr">What actualy happened is that both queries were stuck on waiting (after 3 minutes I decided to investagate as there quries should be extremly fast!).</div>
<div dir="ltr">I ran also this query:</div>
<div dir="ltr"> </div>
<div dir="ltr">
<div>SELECT<br /> pid,<br /> now() - pg_stat_activity.query_start AS duration,<br /> query,<br /> state, *<br />FROM pg_stat_activity<br />WHERE waiting</div>
<div> </div>
<div> </div>
<div>and both users were on waiting. When I stopped my query the other user got imiddiate result, then I reran mine which also finished immidiatly.</div>
<div>I don't understand why both queries were stuck, the logic thing is that one ran and the other one is waiting (if locks aquired etc) it doesnt make senece that both queries are on waiting. waiting for what exactly?</div>
<div> </div>
<div> </div>
<div>Any thoughts on this issue?</div>
</div></div>