On 2019-Jun-13, Oleksii Kliukin wrote: > Makes sense. For the symmetry I have included those that perform lock > upgrades in one session and those that doesn’t, while the other sessions > acquire locks, do updates or deletes. For those that don’t upgrade locks the > test checks that the locks are acquired in the correct order.
Thanks for the updated patch! I'm about to push to branches 9.6-master. It applies semi-cleanly (only pgindent-maturity whitespace conflicts). The [pg11 version of the] patch does applies to 9.5 cleanly ... but the isolation test doesn't work, because isolationtester was not smart enough back then. Since there have been no previous reports of this problem, and to avoid pushing untested code, I'm going to refrain from back-patching there. My guess is that it should work ... In 9.4 there are quite some severe conflicts, because 27846f02c176 was not back-patched there. (The bug number "#8470" still floats in my memory from time to time. Shudder) -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services