agora inbox for pgsql-committers@postgresql.org
help / color / mirror / Atom feedFrom: Peter Eisentraut <peter@eisentraut.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Revert SQL Property Graph Queries (SQL/PGQ)
Date: Mon, 07 Sep 2026 19:33:39 +0000
Message-ID: <E1x3f62-00000003sxF-0zQO@gemulon.postgresql.org> (raw)
Revert SQL Property Graph Queries (SQL/PGQ)
List of commits reverted:
2f094e7ac69 SQL Property Graph Queries (SQL/PGQ)
cd8844e7db6 Make some tests more stable by adding more explicit ordering
182cdf5aeaf pg_dump: Add appropriate version check
c9babbc8816 Dump labels in reproducible order
040a56be4bc Cleanup users and roles in graph_table_rls test
5282bf535e4 Fix some typos and make small stylistic improvements
720f0f89d69 Reject consecutive element patterns of same kind
288ae968726 Add a graph pattern variable only once
c5b3253b8ab Property references are preferred over regular column references
a0dd0702e46 Fix cross variable references in graph pattern causing segfault
2ff289d0393 Check for stack overflow when rewriting graph queries
9082680c34e Fix typos and grammar in graph table rewrite code
ac3bcc041c5 Fix collation of expressions in GRAPH_TABLE COLUMNS clause
9d2979dd685 pg_get_viewdef() and lateral references in COLUMNS of GRAPH_TABLE
891a57c7394 Do not define type for a property graph
dc9e7c9ed93 Handle nodes that may appear in GraphPattern expression trees
f6edd8ed708 Add ORDER BY to test query to stabilize test
1190f858eaf doc: Small synopsis wording change for consistency
d0eac3cafb0 Make spelling consistent
6827de95ee0 Simplify code in objectaddress.c for some property graph objects
5778fb3eafd Fix typo in error message
72498a86989 Handle element label and label property objects in object address functions
4cb2a9863d8 Fix LATERAL references in GRAPH_TABLE with multi-label pattern
9d8cdcbe0c8 Record dependencies on graph labels and properties
2a7e95b659d Readable identity strings for property graph objects
ac0ad6a7c9d Prevent dropping the last label from a property graph element
36aae3d0297 Fix handling of dropping a property not associated with the given label
cc9aa7f3a98 Resolve unknown-type literals in GRAPH_TABLE COLUMNS
d8687368300 Make property graph object descriptions better translatable
45d4c917ff4 Fix properties orphaned by dropping a label
33bfad0f3ca Remove apparent support for SECURITY LABEL ON PROPERTY GRAPH
ccca2cd81b2 Fix pg_dump ACL minimization for PROPERTY GRAPH.
7883ea13ffd Fix replace_property_refs() ignoring the root of expression tree
b820c623dd5 Resolve unknown-type literals in property expressions
01c544e1afb Prohibit locking clauses on GRAPH_TABLE
8d2beee027a Restore the ability to use | and -> as prefix operators.
d2ac26eb9b1 Fix missing space before WHERE in GRAPH_TABLE deparse
4054ec5b4f3 Prohibit GRANT ... ON TABLE on a property graph
77964322d60 doc: Add PROPERTY GRAPH to the access privilege tables
c5e11de2f37 More tab-completion for DROP PROPERTY GRAPH
8ce749f8f65 Disallow aggregates, window functions, and SRFs in GRAPH_TABLE COLUMNS
22d0eebfef7 Report duplicate property and label names with a proper error
41a300ae3df Make generate_queries_for_path_pattern_recurse() interruptible
58af2138740 Fix inferred property graph keys with INCLUDE columns
63f8e9773aa Fix pg_event_trigger_ddl_commands for GRANT ON PROPERTY GRAPH
07df2b25327 doc: reformat GRAPH_TABLE examples
1c8c790ec10 Coerce GRAPH_TABLE pattern WHERE clauses to boolean
plus release notes entries and typedefs.list changes.
Discussion: https://www.postgresql.org/message-id/CAAKRu_bEtjWYWhYxSo0o_t3DaZYRQd5PkC0abA0g9Mp4%2BovH0w%40mail.g...
Branch
------
REL_19_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/2b9e1aff4d3d933ae8ee377fef22c2af9c7797e8
Modified Files
--------------
contrib/pg_overexplain/expected/pg_overexplain.out | 54 -
contrib/pg_overexplain/pg_overexplain.c | 20 -
contrib/pg_overexplain/sql/pg_overexplain.sql | 11 -
doc/src/sgml/catalogs.sgml | 520 +-----
doc/src/sgml/ddl.sgml | 251 ---
doc/src/sgml/features.sgml | 4 +-
doc/src/sgml/func/func-info.sgml | 15 -
doc/src/sgml/information_schema.sgml | 1092 -----------
doc/src/sgml/keywords/sql2023-16-nonreserved.txt | 27 -
doc/src/sgml/keywords/sql2023-16-reserved.txt | 12 -
doc/src/sgml/queries.sgml | 167 --
doc/src/sgml/ref/allfiles.sgml | 3 -
doc/src/sgml/ref/alter_extension.sgml | 3 +-
doc/src/sgml/ref/alter_property_graph.sgml | 301 ---
doc/src/sgml/ref/comment.sgml | 1 -
doc/src/sgml/ref/create_property_graph.sgml | 318 ----
doc/src/sgml/ref/drop_property_graph.sgml | 111 --
doc/src/sgml/ref/grant.sgml | 7 +-
doc/src/sgml/ref/psql-ref.sgml | 13 +-
doc/src/sgml/ref/revoke.sgml | 7 -
doc/src/sgml/ref/select.sgml | 43 -
doc/src/sgml/reference.sgml | 3 -
doc/src/sgml/release-19.sgml | 30 -
src/backend/catalog/aclchk.c | 56 +-
src/backend/catalog/dependency.c | 30 -
src/backend/catalog/heap.c | 6 +-
src/backend/catalog/information_schema.sql | 366 ----
src/backend/catalog/objectaddress.c | 421 -----
src/backend/catalog/pg_class.c | 2 -
src/backend/catalog/sql_features.txt | 100 -
src/backend/commands/Makefile | 1 -
src/backend/commands/alter.c | 28 +-
src/backend/commands/dropcmds.c | 1 -
src/backend/commands/event_trigger.c | 3 -
src/backend/commands/meson.build | 1 -
src/backend/commands/propgraphcmds.c | 1959 --------------------
src/backend/commands/seclabel.c | 1 -
src/backend/commands/tablecmds.c | 20 +-
src/backend/executor/execMain.c | 17 +-
src/backend/nodes/nodeFuncs.c | 102 -
src/backend/nodes/outfuncs.c | 9 -
src/backend/nodes/print.c | 4 -
src/backend/nodes/readfuncs.c | 9 -
src/backend/optimizer/path/allpaths.c | 10 -
src/backend/optimizer/prep/prepjointree.c | 8 -
src/backend/parser/Makefile | 1 -
src/backend/parser/analyze.c | 14 +-
src/backend/parser/gram.y | 721 +------
src/backend/parser/meson.build | 1 -
src/backend/parser/parse_agg.c | 11 -
src/backend/parser/parse_clause.c | 176 --
src/backend/parser/parse_collate.c | 1 -
src/backend/parser/parse_expr.c | 17 -
src/backend/parser/parse_func.c | 3 -
src/backend/parser/parse_graphtable.c | 397 ----
src/backend/parser/parse_relation.c | 99 +-
src/backend/parser/parse_target.c | 5 -
src/backend/parser/scan.l | 13 +-
src/backend/rewrite/Makefile | 1 -
src/backend/rewrite/meson.build | 1 -
src/backend/rewrite/rewriteGraphTable.c | 1343 --------------
src/backend/rewrite/rewriteHandler.c | 12 -
src/backend/tcop/utility.c | 34 -
src/backend/utils/adt/acl.c | 7 -
src/backend/utils/adt/ruleutils.c | 553 ------
src/backend/utils/cache/lsyscache.c | 38 -
src/backend/utils/cache/plancache.c | 6 +-
src/bin/pg_dump/common.c | 3 +-
src/bin/pg_dump/dumputils.c | 3 -
src/bin/pg_dump/pg_backup_archiver.c | 1 -
src/bin/pg_dump/pg_dump.c | 121 +-
src/bin/pg_dump/t/002_pg_dump.pl | 28 -
src/bin/psql/command.c | 3 +-
src/bin/psql/describe.c | 96 +-
src/bin/psql/help.c | 5 +-
src/bin/psql/tab-complete.in.c | 65 +-
src/fe_utils/psqlscan.l | 8 +-
src/include/catalog/Makefile | 7 +-
src/include/catalog/catversion.h | 2 +-
src/include/catalog/meson.build | 5 -
src/include/catalog/pg_class.h | 1 -
src/include/catalog/pg_proc.dat | 3 -
src/include/catalog/pg_propgraph_element.h | 118 --
src/include/catalog/pg_propgraph_element_label.h | 55 -
src/include/catalog/pg_propgraph_label.h | 55 -
src/include/catalog/pg_propgraph_label_property.h | 63 -
src/include/catalog/pg_propgraph_property.h | 64 -
src/include/commands/propgraphcmds.h | 23 -
src/include/nodes/parsenodes.h | 139 --
src/include/nodes/primnodes.h | 24 -
src/include/parser/analyze.h | 3 -
src/include/parser/kwlist.h | 9 -
src/include/parser/parse_graphtable.h | 24 -
src/include/parser/parse_node.h | 24 -
src/include/parser/parse_relation.h | 8 -
src/include/rewrite/rewriteGraphTable.h | 21 -
src/include/tcop/cmdtaglist.h | 3 -
src/include/utils/acl.h | 1 -
src/include/utils/lsyscache.h | 3 -
src/interfaces/ecpg/preproc/pgc.l | 12 +-
src/interfaces/ecpg/test/ecpg_schedule | 1 -
src/interfaces/ecpg/test/expected/sql-sqlpgq.c | 285 ---
.../ecpg/test/expected/sql-sqlpgq.stderr | 190 --
.../ecpg/test/expected/sql-sqlpgq.stdout | 7 -
src/interfaces/ecpg/test/sql/.gitignore | 2 -
src/interfaces/ecpg/test/sql/Makefile | 1 -
src/interfaces/ecpg/test/sql/meson.build | 1 -
src/interfaces/ecpg/test/sql/sqlpgq.pgc | 105 --
src/test/regress/expected/alter_generic.out | 51 +-
.../regress/expected/create_property_graph.out | 999 ----------
src/test/regress/expected/event_trigger.out | 33 -
src/test/regress/expected/graph_table.out | 1134 -----------
src/test/regress/expected/graph_table_rls.out | 789 --------
src/test/regress/expected/object_address.out | 33 +-
src/test/regress/expected/oidjoins.out | 12 -
src/test/regress/expected/privileges.out | 99 -
src/test/regress/parallel_schedule | 6 +-
src/test/regress/sql/alter_generic.sql | 34 -
src/test/regress/sql/create_property_graph.sql | 404 ----
src/test/regress/sql/event_trigger.sql | 20 -
src/test/regress/sql/graph_table.sql | 633 -------
src/test/regress/sql/graph_table_rls.sql | 378 ----
src/test/regress/sql/object_address.sql | 13 +-
src/test/regress/sql/privileges.sql | 59 -
src/tools/pgindent/typedefs.list | 24 -
125 files changed, 77 insertions(+), 15857 deletions(-)
view thread (2+ messages)
Message-ID: <E1x3f62-00000003sxF-0zQO@gemulon.postgresql.org>
Permalink: ../E1x3f62-00000003sxF-0zQO@gemulon.postgresql.org/
Also on: postgresql.org/message-id/E1x3f62-00000003sxF-0zQO@gemulon.postgresql.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: peter@eisentraut.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Revert SQL Property Graph Queries (SQL/PGQ)
In-Reply-To: <E1x3f62-00000003sxF-0zQO@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox