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

From Ayush Vatsa
Subject Re: Clarification on Role Access Rights to Table Indexes
Date
Msg-id CACX+KaP+6U9jf=GT4wpR7TvRvSMtTAhz=vP2Zr+ZdUFVZzqNsA@mail.gmail.com
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
> From a quick test and skim of the relevant
> code, I think your patch is fine, though
Thanks for reviewing.

> And IIUC
> DROP TABLE first acquires a lock on the table and its dependent objects
> (e.g., indexes) before any actual deletions, so AFAICT there's no problem
> with using it in pg_class_aclcheck() and get_rel_name(), either.
True, I have also verified that from [1], hence I think we are safe here.
Maybe we can move ahead with the patch if we can see no other concerns.


Thanks,
Ayush Vatsa
SDE AWS

pgsql-hackers by date:

Previous
From: Joseph Koshakow
Date:
Subject: Re: Assert when executing query on partitioned table
Next
From: Tom Lane
Date:
Subject: Printing window function OVER clauses in EXPLAIN