On Tue, Mar 17, 2026 at 12:35 AM Andrew Dunstan <[email protected]> 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
