On Sun, Aug 23, 2026 at 2:12 PM Taha Naveed <[email protected]> wrote: > > Hi, > > I also encountered an issue with pg_get_propgraphdef() and pg_dump. > > CREATE TABLE wr ( > id int PRIMARY KEY, > x text > ); > > CREATE PROPERTY GRAPH gwr > VERTEX TABLES ( > wr PROPERTIES (wr AS whole) > ); > > SELECT pg_get_propgraphdef('gwr'::regclass); > ERROR: cache lookup failed for attribute 0 of relation ... > > The graph itself works, and the whole row property can be queried through > GRAPH_TABLE. However, pg_dump also fails because it calls > pg_get_propgraphdef(). > Reproduced this on PG 19beta3 as well as current master.
Agreed this is an issue. The fix is to use get_target_list() to deparse the PROPERTIES clause. I have a patch for this. Will post when SQL/PGQ is resurrected. -- Best Wishes, Ashutosh Bapat
