Hi Daniil On 03/05/2026 10:53, Daniil Davydov wrote:
Autovacuum locks orphaned table's oid before deleting it. LOCK TABLE command also locks the oid of the specified table. If we want to make sure that autovacuum can acquire the mentioned lock (i.e. cover this behavior using tests), I suggest testing it using the LOCK TABLE command.
+1 for the extra test.
Please, see the attached patch that ensures that cross-session LOCK TABLE works properly.
I guess you should either add it to the 0001 sent by Alexander, or create a 0003. Right now the cfbot is complaining, as 013_temp_obj_multisession.pl still does not exist :)
Best, Jim
