On Mon, Feb 17, 2025 at 2:57 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > Ayush Vatsa <ayushvatsa1...@gmail.com> writes: > >> As it stands, a superuser can prewarm an index (because she bypasses all > >> privilege checks including this one), but nobody else can. > > > That's not fully true. Any role can prewarm an index if the role has the > > correct privileges. > > Ah, right. An index will have null pg_class.relacl, which'll be > interpreted as "owner has all rights", so it will work for the > table owner too. Likely this explains the lack of prior complaints. > It's still a poor design IMO.
I'm not sure if I'd call that a "design". Sounds like I just made a mistake here. -- Robert Haas EDB: http://www.enterprisedb.com
