Re: Extension pg_trgm, permissions and pg_dump order

From: Noah Misch <noah(at)leadboat(dot)com>
To: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, 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-06-13 03:45:51
Message-ID: 20220613034551.GB3728437@rfd.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

On Wed, Jun 08, 2022 at 10:17:08PM -0700, Noah Misch wrote:
> On Sun, Jun 05, 2022 at 11:30:56PM -0700, Noah Misch wrote:
> > On Fri, Jun 03, 2022 at 11:17:24AM -0700, Nathan Bossart wrote:
> > > On Tue, May 31, 2022 at 08:28:55AM -0700, Nathan Bossart wrote:
> > > > I've spent some time looking at all the code impacted by a117ceb and
> > > > 0abc1a0, and I've yet to identify any additional problems besides the one
> > > > with ResolveOpClass(). However, I'm far from confident in this analysis,
> > > > and I still need to try out the ereport() approach that Noah suggested. I
> > > > would welcome any assistance identifying other problem areas.
> > >
> > > Ah, I think I am missing something. For example, the code that identifies
> > > the exclusion operator (immediately following the call to ResolveOpClass())
> > > is likely subject to a similar problem.
> >
> > That would not surprise me. Do you have what you need to continue?
>
> I'll use that window on Sunday to review what you have. If you have work in
> progress, please get it to the mailing list by then.

I have the patch mostly done. I will send something late on Wednesday.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2022-06-13 06:45:05 Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error
Previous Message Jeff Janes 2022-06-13 02:23:12 Re: Unable to make use of "deep" JSONB index

Browse pgsql-general by date

  From Date Subject
Next Message Bryn Llewellyn 2022-06-13 05:43:16 "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"
Previous Message Zheng Li 2022-06-12 06:46:27 Re: Support logical replication of DDLs