Re: DROP OWNED CASCADE vs Temp tables

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Mithun Cy <mithun(dot)cy(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: DROP OWNED CASCADE vs Temp tables
Date: 2020-02-05 21:13:02
Message-ID: 20200205211302.GA32650@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs pgsql-hackers

On 2020-Jan-23, Alvaro Herrera wrote:

> This is not a 100% solution: there's the cases when the user is removed
> from an ACL and from a policy, and those deletions are done directly
> instead of accumulating to the end for a mass deletion.
> I had to export AcquireDeletionLock (previously a static in
> dependency.c). I wonder if I should export ReleaseDeletionLock too, for
> symmetry.

FWIW I'm going to withhold this bugfix until after the next set of
minors are out. I'd rather not find out later that I have no way to fix
9.4 if I break it, for a bug that has existed forever ...

Álvaro Herrera
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to


Browse pgsql-bugs by date

  From Date Subject
Next Message Jehan-Guillaume de Rorthais 2020-02-05 23:49:48 Another FK violation when referencing a multi-level partitioned table
Previous Message Andrew Gierth 2020-02-05 19:22:20 Re: BUG #16242: convert_tuple_* not handling missing values correctly

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2020-02-05 21:27:14 Re: Do not check unlogged indexes on standby
Previous Message Mahendra Singh Thalor 2020-02-05 20:26:58 Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager