On Thu, Jan 22, 2026 at 5:26 PM Henson Choi <[email protected]> wrote: > > Hi Ajay, > > I looked into this and it appears to be expected PostgreSQL behavior rather > than a GRAPH_TABLE-specific issue.
+1. This behaviour is documented in [1] " Inherited queries perform access permission checks on the parent table only. Thus, for example, granting UPDATE permission on the cities table implies permission to update rows in the capitals table as well, when they are accessed through cities. This preserves the appearance that the data is (also) in the parent table. But the capitals table could not be updated directly without an additional grant. In a similar way, the parent table's row security policies (see Section 5.9) are applied to rows coming from child tables during an inherited query. A child table's policies, if any, are applied only when it is the table explicitly named in the query; and in that case, any policies attached to its parent(s) are ignored. " [1] https://www.postgresql.org/docs/current/ddl-inherit.html#:~:text=In%20a%20similar%20way%2C%20the%20parent%20table's,policies%20attached%20to%20its%20parent(s)%20are%20ignored. -- Best Wishes, Ashutosh Bapat
