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

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
7afa11feca6 Prevent dropping the last label from a property graph element
96418a6da9d Fix handling of dropping a property not associated with the given label
efd7d8d7d49 Resolve unknown-type literals in GRAPH_TABLE COLUMNS
e0ff7fd9aa2 Make property graph object descriptions better translatable
0e4f0827f63 Fix properties orphaned by dropping a label
73dfe79fd60 Remove apparent support for SECURITY LABEL ON PROPERTY GRAPH
592de8bd21e Fix pg_dump ACL minimization for PROPERTY GRAPH.
16a4b3ef8ee Fix replace_property_refs() ignoring the root of expression tree
57f93af36f0 Resolve unknown-type literals in property expressions
2e6578292a9 Prohibit locking clauses on GRAPH_TABLE
2521f9e75e9 doc: Fix SQL quoting in example
0316593146d Restore the ability to use | and -> as prefix operators.
780fa49746d Fix missing space before WHERE in GRAPH_TABLE deparse
fa62d4f6ea7 Prohibit GRANT ... ON TABLE on a property graph
63c3bbb39f9 doc: Add PROPERTY GRAPH to the access privilege tables
0a51a06cdb0 More tab-completion for DROP PROPERTY GRAPH
f585671055d Disallow aggregates, window functions, and SRFs in GRAPH_TABLE COLUMNS
9b917a93116 Report duplicate property and label names with a proper error
a82e33a83d7 Make generate_queries_for_path_pattern_recurse() interruptible
3c982c9bf1a Add test for view referencing labels shared by vertex and edge tables
8646d1d5904 Fix inferred property graph keys with INCLUDE columns
0417bf52969 Fix pg_event_trigger_ddl_commands for GRANT ON PROPERTY GRAPH
a20d3e35f2c doc: reformat GRAPH_TABLE examples
792094a5ce8 Coerce GRAPH_TABLE pattern WHERE clauses to boolean

plus typedefs.list changes.

Discussion: https://www.postgresql.org/message-id/CAAKRu_bEtjWYWhYxSo0o_t3DaZYRQd5PkC0abA0g9Mp4%2BovH0w%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/b1f106c80cbeb18d3a0219994d98a51a6eca8ede

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 -
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 | 1153 ------------
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 | 646 -------
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 -
124 files changed, 77 insertions(+), 15859 deletions(-)