Re: Extension pg_trgm, permissions and pg_dump order

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: Nathan Bossart <nathandbossart(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org, Färber, Franz-Josef (StMUK) <Franz-Josef(dot)Faerber(at)stmuk(dot)bayern(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Extension pg_trgm, permissions and pg_dump order
Date: 2022-05-31 04:30:11
Message-ID: YpWZ02YEN9pipA6M@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

On Sat, May 28, 2022 at 09:34:03PM -0700, Noah Misch wrote:
> On Sat, May 28, 2022 at 08:30:33PM -0700, Nathan Bossart wrote:
>> I started looking at the problem and hacked together a
>> proof-of-concept based on your first candidate that seems to fix the
>> reported issue. However, from the upthread discussion, it is not clear
>> whether there is agreement on the approach. IIUC there are still many
>> other code paths that would require a similar treatment, so perhaps
>> identifying all of those would be a good next step.
>
> Agreed. To identify them, perhaps put an ereport(..., errbacktrace()) in
> aclmask(), then write some index-creating DDL that refers to the
> largest-possible number of objects.

While we've reached an agreement on the thread related to the
corruption caused by the incorrect snapshots for concurrent index
builds, this thread seems to be stalling a bit and we should try to
move on before getting a release out. Is somebody looking at what we
have here?
--
Michael

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrey Borodin 2022-05-31 06:47:11 Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY
Previous Message Michael Paquier 2022-05-31 04:25:17 Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2022-05-31 06:36:55 Re: existing row not found by SELECT ... WHERE CTID = ?
Previous Message Jeff Janes 2022-05-30 22:16:52 Re: autovacuum on primary blocking queries on replica?