Re: PGQ catalog representation and pg_dump support - Mailing list pgsql-hackers

On Sun, Aug 23, 2026 at 2:12 PM Taha Naveed <m.taha.naveed27@gmail.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
becauseit 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