Re: SQL Property Graph Queries (SQL/PGQ)

On Thu, Jan 22, 2026 at 5:26 PM Henson Choi <assam258(at)gmail(dot)com> 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