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

On Tue, Mar 17, 2026 at 12:35 AM Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
>
>
> -
>
>
> 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.

+1 for sorting by label names, the patch LGTM.

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

+1

>
>
> cheers
>
>
> andrew
>
>
>
> --
> Andrew Dunstan
> EDB: https://www.enterprisedb.com

--
Regards
Junwang Zhao