Re: PGQ catalog representation and pg_dump support

On Sun, Aug 23, 2026 at 2:12 PM Taha Naveed <m(dot)taha(dot)naveed27(at)gmail(dot)com> 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