pgsql: Revert SQL Property Graph Queries (SQL/PGQ) - Mailing list pgsql-committers
| From | Peter Eisentraut |
|---|---|
| Subject | pgsql: Revert SQL Property Graph Queries (SQL/PGQ) |
| Date | |
| Msg-id | E1x3f62-00000003sxD-0vdk@gemulon.postgresql.org Whole thread |
| List | pgsql-committers |
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(-)
pgsql-committers by date:
Previous
From: Amit KapilaDate:
Subject: pgsql: Reset conflict slot's xmin when a subscription (re)starts retent