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.gmail.com 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(-)
