Isn't partition drop code seriously at risk of deadlock? - Mailing list pgsql-hackers

From Tom Lane
Subject Isn't partition drop code seriously at risk of deadlock?
Date
Msg-id 1990.1511827471@sss.pgh.pa.us
Whole thread Raw
Responses Re: Isn't partition drop code seriously at risk of deadlock?  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
List pgsql-hackers
The complaint in bug #14927 that heap_drop_with_catalog is not bothering
to check for SearchSysCache lookup failure (in code evidently newly added
for the partition feature) seems to me to be only scratching the surface
of what's wrong with that code.  In particular, I do not understand how
it can possibly be deadlock-free to be trying to grab AccessExclusiveLock
on a partition's parent table when we already have such a lock on the
partition.  Which we do, or at least had better, long before we get to
heap_drop_with_catalog.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] More stats about skipped vacuums
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Timeline ID in backup_label file