pgsql: Heed lock protocol in DROP OWNED BY

2020-05-06 Thread Alvaro Herrera
Heed lock protocol in DROP OWNED BY We were acquiring object locks then deleting objects one by one, instead of acquiring all object locks first, ignoring those that did not exist, and then deleting all objects together. The latter is the correct protocol to use, and what this commits changes to

pgsql: Heed lock protocol in DROP OWNED BY

2020-05-06 Thread Alvaro Herrera
Heed lock protocol in DROP OWNED BY We were acquiring object locks then deleting objects one by one, instead of acquiring all object locks first, ignoring those that did not exist, and then deleting all objects together. The latter is the correct protocol to use, and what this commits changes to

pgsql: Heed lock protocol in DROP OWNED BY

2020-05-06 Thread Alvaro Herrera
Heed lock protocol in DROP OWNED BY We were acquiring object locks then deleting objects one by one, instead of acquiring all object locks first, ignoring those that did not exist, and then deleting all objects together. The latter is the correct protocol to use, and what this commits changes to

pgsql: Heed lock protocol in DROP OWNED BY

2020-05-06 Thread Alvaro Herrera
Heed lock protocol in DROP OWNED BY We were acquiring object locks then deleting objects one by one, instead of acquiring all object locks first, ignoring those that did not exist, and then deleting all objects together. The latter is the correct protocol to use, and what this commits changes to

pgsql: Heed lock protocol in DROP OWNED BY

2020-05-06 Thread Alvaro Herrera
Heed lock protocol in DROP OWNED BY We were acquiring object locks then deleting objects one by one, instead of acquiring all object locks first, ignoring those that did not exist, and then deleting all objects together. The latter is the correct protocol to use, and what this commits changes to

pgsql: Heed lock protocol in DROP OWNED BY

2020-05-06 Thread Alvaro Herrera
Heed lock protocol in DROP OWNED BY We were acquiring object locks then deleting objects one by one, instead of acquiring all object locks first, ignoring those that did not exist, and then deleting all objects together. The latter is the correct protocol to use, and what this commits changes to