Re: Clarification on Role Access Rights to Table Indexes - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: Clarification on Role Access Rights to Table Indexes
Date
Msg-id aOkzoH-pXdBr0ewf@nathan
Whole thread Raw
In response to Re: Clarification on Role Access Rights to Table Indexes  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: Clarification on Role Access Rights to Table Indexes
List pgsql-hackers
On Thu, Oct 09, 2025 at 04:18:03PM -0500, Nathan Bossart wrote:
> There's a similar pattern in get_rel_from_relname() in dblink.c, which also
> seems to only be used with an AccessShareLock (like pg_prewarm).  My best
> guess from reading lots of code, commit messages, and old e-mails in the
> archives is that the original check-privileges-before-locking work was
> never completed.

I added an 0004 that changes dblink to use RangeVarGetRelidExtended().

> I'm currently leaning towards continuing with v4 of the patch set.  0001
> and 0003 are a little weird in that a concurrent change could lead to a
> "could not find parent table" ERROR, but IIUC that is an extremely remote
> possibility.

After sleeping on it, I still think this is the right call.  In any case,
I've spent way too much time on this stuff, so I plan to commit the
attached soon.

-- 
nathan

Attachment

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: ReadRecentBuffer() doesn't scale well
Next
From: Ranier Vilela
Date:
Subject: Re: Fix array access (src/bin/pg_dump/pg_dump.c)