SQL COMMANDS / VERSION COMPARISON
What changed?
SQL Commands · PostgreSQL 19 beta 3 → 20 devel
Development snapshot. These definitions may change before release.
0 added · 3 removed · 7 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
changedALTER TABLE
--- 19 beta 3
+++ 20 devel
@@ -14,12 +14,6 @@
ATTACH PARTITION partition_name { FOR VALUES partition_bound_spec | DEFAULT }
ALTER TABLE [ IF EXISTS ] name
DETACH PARTITION partition_name [ CONCURRENTLY | FINALIZE ]
-ALTER TABLE [ IF EXISTS ] name
-MERGE PARTITIONS (partition_name1, partition_name2 [, ...]) INTO partition_name
-ALTER TABLE [ IF EXISTS ] name
-SPLIT PARTITION partition_name INTO
-(PARTITION partition_name1 { FOR VALUES partition_bound_spec | DEFAULT },
-PARTITION partition_name2 { FOR VALUES partition_bound_spec | DEFAULT } [, ...])
where action is one of:
changedCREATE AGGREGATE
--- 19 beta 3
+++ 20 devel
@@ -18,6 +18,7 @@
[ , MFINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ]
[ , MINITCOND = minitial_condition ]
[ , SORTOP = sort_operator ]
+[ , SUPPORT = psfunc ]
[ , PARALLEL = { SAFE | RESTRICTED | UNSAFE } ]
)
@@ -30,6 +31,7 @@
[ , FINALFUNC_EXTRA ]
[ , FINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ]
[ , INITCOND = initial_condition ]
+[ , SUPPORT = psfunc ]
[ , PARALLEL = { SAFE | RESTRICTED | UNSAFE } ]
[ , HYPOTHETICAL ]
)
@@ -57,4 +59,5 @@
[ , MFINALFUNC_MODIFY = { READ_ONLY | SHAREABLE | READ_WRITE } ]
[ , MINITCOND = minitial_condition ]
[ , SORTOP = sort_operator ]
+[ , SUPPORT = psfunc ]
)changedGRANT
--- 19 beta 3
+++ 20 devel
@@ -59,11 +59,6 @@
TO role_specification [, ...] [ WITH GRANT OPTION ]
[ GRANTED BY role_specification ]
-GRANT { SELECT | ALL [ PRIVILEGES ] }
-ON PROPERTY GRAPH graph_name [, ...]
-TO role_specification [, ...] [ WITH GRANT OPTION ]
-[ GRANTED BY role_specification ]
-
GRANT { { CREATE | USAGE } [, ...] | ALL [ PRIVILEGES ] }
ON SCHEMA schema_name [, ...]
TO role_specification [, ...] [ WITH GRANT OPTION ]changedREVOKE
--- 19 beta 3
+++ 20 devel
@@ -82,13 +82,6 @@
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
-{ SELECT | ALL [ PRIVILEGES ] }
-ON PROPERTY GRAPH graph_name [, ...]
-FROM role_specification [, ...]
-[ GRANTED BY role_specification ]
-[ CASCADE | RESTRICT ]
-
-REVOKE [ GRANT OPTION FOR ]
{ { CREATE | USAGE } [, ...] | ALL [ PRIVILEGES ] }
ON SCHEMA schema_name [, ...]
FROM role_specification [, ...]changedALTER EXTENSION
--- 19 beta 3 +++ 20 devel @@ -20,7 +20,6 @@ OPERATOR FAMILY object_name USING index_method | [ PROCEDURAL ] LANGUAGE object_name | PROCEDURE procedure_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] | -PROPERTY GRAPH object_name | ROUTINE routine_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] | SCHEMA object_name | SEQUENCE object_name |
changedSELECT
--- 19 beta 3
+++ 20 devel
@@ -25,7 +25,6 @@
[ LATERAL ] function_name ( [ argument [, ...] ] ) AS ( column_definition [, ...] )
[ LATERAL ] ROWS FROM( function_name ( [ argument [, ...] ] ) [ AS ( column_definition [, ...] ) ] [, ...] )
[ WITH ORDINALITY ] [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
-GRAPH_TABLE ( graph_name MATCH graph_pattern COLUMNS ( { expression [ AS name ] } [, ...] ) ) [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
from_item join_type from_item { ON join_condition | USING ( join_column [, ...] ) [ AS join_using_alias ] }
from_item NATURAL join_type from_item
from_item CROSS JOIN from_itemchangedCOMMENT
--- 19 beta 3 +++ 20 devel @@ -24,7 +24,6 @@ POLICY policy_name ON table_name | [ PROCEDURAL ] LANGUAGE object_name | PROCEDURE procedure_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] | -PROPERTY GRAPH object_name PUBLICATION object_name | ROLE object_name | ROUTINE routine_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] |
removedCREATE PROPERTY GRAPH
--- 19 beta 3
+++ 20 devel
@@ -1,20 +0,0 @@
-CREATE [ TEMP | TEMPORARY ] PROPERTY GRAPH name
-[ {VERTEX|NODE} TABLES ( vertex_table_definition [, ...] ) ]
-[ {EDGE|RELATIONSHIP} TABLES ( edge_table_definition [, ...] ) ]
-
-where vertex_table_definition is:
-vertex_table_name [ AS alias ] [ KEY ( column_name [, ...] ) ] [ element_table_label_and_properties ]
-
-and edge_table_definition is:
-edge_table_name [ AS alias ] [ KEY ( column_name [, ...] ) ]
-SOURCE [ KEY ( column_name [, ...] ) REFERENCES ] source_table [ ( column_name [, ...] ) ]
-DESTINATION [ KEY ( column_name [, ...] ) REFERENCES ] dest_table [ ( column_name [, ...] ) ]
-[ element_table_label_and_properties ]
-
-and element_table_label_and_properties is either:
-
-NO PROPERTIES | PROPERTIES ALL COLUMNS | PROPERTIES ( { expression [ AS property_name ] } [, ...] )
-
-or:
-
-{ { LABEL label_name | DEFAULT LABEL } [ NO PROPERTIES | PROPERTIES ALL COLUMNS | PROPERTIES ( { expression [ AS property_name ] } [, ...] ) ] } [...]removedALTER PROPERTY GRAPH
--- 19 beta 3
+++ 20 devel
@@ -1,29 +0,0 @@
-ALTER PROPERTY GRAPH name ADD
-[ {VERTEX|NODE} TABLES ( vertex_table_definition [, ...] ) ]
-[ {EDGE|RELATIONSHIP} TABLES ( edge_table_definition [, ...] ) ]
-
-ALTER PROPERTY GRAPH name DROP
-{VERTEX|NODE} TABLES ( vertex_table_alias [, ...] ) [ CASCADE | RESTRICT ]
-
-ALTER PROPERTY GRAPH name DROP
-{EDGE|RELATIONSHIP} TABLES ( edge_table_alias [, ...] ) [ CASCADE | RESTRICT ]
-
-ALTER PROPERTY GRAPH name ALTER
-{VERTEX|NODE|EDGE|RELATIONSHIP} TABLE element_table_alias
-{ ADD LABEL label_name [ NO PROPERTIES | PROPERTIES ALL COLUMNS | PROPERTIES ( { expression [ AS property_name ] } [, ...] ) ] } [ ... ]
-
-ALTER PROPERTY GRAPH name ALTER
-{VERTEX|NODE|EDGE|RELATIONSHIP} TABLE element_table_alias
-DROP LABEL label_name [ CASCADE | RESTRICT ]
-
-ALTER PROPERTY GRAPH name ALTER
-{VERTEX|NODE|EDGE|RELATIONSHIP} TABLE element_table_alias
-ALTER LABEL label_name ADD PROPERTIES ( { expression [ AS property_name ] } [, ...] )
-
-ALTER PROPERTY GRAPH name ALTER
-{VERTEX|NODE|EDGE|RELATIONSHIP} TABLE element_table_alias
-ALTER LABEL label_name DROP PROPERTIES ( property_name [, ...] ) [ CASCADE | RESTRICT ]
-
-ALTER PROPERTY GRAPH name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
-ALTER PROPERTY GRAPH name RENAME TO new_name
-ALTER PROPERTY GRAPH [ IF EXISTS ] name SET SCHEMA new_schemaremovedDROP PROPERTY GRAPH
--- 19 beta 3 +++ 20 devel @@ -1 +0,0 @@ -DROP PROPERTY GRAPH [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]