Re: pgsql: SQL Property Graph Queries (SQL/PGQ)

-


On 2026-03-16 Mo 5:20 AM, Peter Eisentraut wrote:
> SQL Property Graph Queries (SQL/PGQ)
>
> Implementation of SQL property graph queries, according to SQL/PGQ
> standard (ISO/IEC 9075-16:2023).
>
> This adds:
>
> - GRAPH_TABLE table function for graph pattern matching
> - DDL commands CREATE/ALTER/DROP PROPERTY GRAPH
> - several new system catalogs and information schema views
> - psql \dG command
> - pg_get_propgraphdef() function for pg_dump and psql
>
> A property graph is a relation with a new relkind RELKIND_PROPGRAPH.
> It acts like a view in many ways.  It is rewritten to a standard
> relational query in the rewriter.  Access privileges act similar to a
> security invoker view.  (The security definer variant is not currently
> implemented.)
>
> Starting documentation can be found in doc/src/sgml/ddl.sgml and
> doc/src/sgml/queries.sgml.
>

The output of make_propgraphdef_labels() is not stable in the face of an 
upgrade which will not preserve the OID sort of the labels. The explains 
the failure at

<https://buildfarm.postgresql.org/cgi-bin/show_stage_log.pl?nm=crake&dt=2026-03-16%2009%3A27%3A04&stg=xversion-upgrade-HEAD-HEAD>.

I think we need to sort the labels by name, along the lines of the 
attached. Or else teach the binary upgrade code to use the same labels, 
as we do for some other things. Not sure how possible that is, nor how 
worth it.

We also need to fence the dependency check in pg_dump.c (also in the 
attached patch)


cheers


andrew



--
Andrew Dunstan
EDB: https://www.enterprisedb.com