Horton

Re: DROP OWNED CASCADE vs Temp tables

Ahsan Hadi <ahsan.hadi@gmail.com>

View thread View on postgr.es
From: ahsan hadi <ahsan.hadi@gmail.com>
To: pgsql-hackers@lists.postgresql.org
Cc: Álvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2020-02-19T13:59:21Z
Lists: pgsql-bugs, pgsql-hackers 
The following review has been posted through the commitfest application:
make installcheck-world:  tested, passed
Implements feature:       tested, passed
Spec compliant:           tested, passed
Documentation:            not tested

I have tested the patch with REL_12_STABLE for the given error scenario by running the "CREATE TEMPORARY TABLE..." and "DROP OWNED BY..." commands concurrently using parallel background workers. I have also tested a few related scenarios and the patch does seem to fix the reported bug. Ran make installcheck-world, no difference with and without patch.

Commits

  1. Heed lock protocol in DROP OWNED BY